How to format data for a custom group

10-11  Source: Network gathering  Views:0 

Advertisement
Hi all
I have a pivot table with Actual and Budget as columns and some accounts in the rows. Since I'm using the account hierarchical column, I created custom groups for the accounts using the Selection steps pane. For example, I created a new group called Profit to combine 3 different Profit accounts and display one Profit line.
Now I want to format the data for the Profit group. I right-click on the Profit group, choose to edit the group and click on the Format button on the bottom left corner. I add some formatting, e.g. borders. When I now view the pivot table, borders have been applied to the label of the group - so the word Profit is now bordered. However, the values in the Actual and Budget columns do not have a border. Don't know what I'm missing, but I want both the group label and the values to be formatted the same way.
How can I apply formatting to the data/values for the custom group?
Yeah tried that already, it formats the entire column whereas I need just the values for the Profit row to be formatted. Seems it is a limitation only when using custom groups?
Related articles
  • How to format data for a custom group 10-11

    Hi all I have a pivot table with Actual and Budget as columns and some accounts in the rows. Since I'm using the account hierarchical column, I created custom groups for the accounts using the Selection steps pane. For example, I created a new group

  • How to set a default date for a custom field of Date type in project server 2010. 11-30

    hi, can somebody help  me. How Can i set the default date for a custom field of date type in project server 2010 ?Dear Rohan, You can set default value to custom field thru Lookup table. Assign lookup table to custom field and set default value to so

  • How to create customer master data for walking customer in retail 11-30

    hi experts !!!!!! for retail industry e.g books trading industry how to create customer master data for walking customer in retail its dummy or one time customer if i create one time customer then same customer number can i use for every new order an

  • How to assign credit limit to customer group 11-30

    hi, sap gurus, how to assign credit limit to customer group. can we do that if we can plzhelp me regards, balaji.t 09990019711.hi, You can assign a credit limit to a group of customers, as well as to an individual customer. If a company has different

  • How to populate data for 2LIS_40_REVAL, 2LIS_43_POSCAS and 2LIS_44_POSREC 10-11

    Hi How to populate data for 2LIS_40_REVAL, 2LIS_43_POSCAS and 2LIS_44_POSREC datasources at RSA3? I'm very new to retail BI. I think there is no setup tables for Retail infosources. Any IDoc or BAPI activation is required or other procedure? We are i

  • MRP is not considering material availability dates for sorting customer ord 11-30

    Hello Experts, MRP is not considering material availability dates for sorting customer order/ sales order in sequence (thatu2019s is oldest from newest in order) in MD04. Please suggest. Thanks, OmOm, No.  Aside from my obvious desire to preserve my

  • How to reserve stock for particular customer? 11-30

    HI all, How to reserve stock for particular customer when they has approved a particular batch? Please tell me all the possibles. Thank you. Richard> Richard.Wang wrote: > HI all, > > How to reserve stock for particular customer when they has

  • How to get data for current week and previous week using customer exit in Bex. 10-11

    Hi everyone, I have a scenario in which I need to display data for current week and previous week (based on "sy_datum" the program has to calculate current week and previous week) in Bex using  Customer exit. I have created one variable in Bex Q

  • How to upload data for custom infotype 11-30

    Hi  Friends Can we use HR_INFOTYPE_OPERATIONS   FM  for custom infotype too  or is there other way or other Standard FM to upload data for custom infotype  starting with 9000..etc. Points will be there for sure. Thanks Meeta & RoopaThanks for quick r

  • How to copy data for certain member from one dimension to another dimension 11-30

    Dear , I want to copy data for certain member ("511102") from one dimension to another combinations of dimensions , I have the following combinations for "511102" : _("Budget2012","FY12","Working.V01",&quo

  • How to add the User in customized Group. 10-11

    Hi All,      If we create any User in SAP Portal then that user is assigned to everyone group by default.Now i have one custom group,say 'ABC'.what i want is, which ever user is being created through SAP Portal should be added to this group. one way

  • How to display data from 2 different groups in a single table 10-11

    Hi, Following is the requirement: The XML Content is below ListOf_ssAssetMgmtAsset> -<ssAssetMgmtAsset> <ssAccountName>1-1D09-83031</ssAccountName> <ssAccountPrimaryCountry>USA</ssAccountPrimaryCountry> <ssAssetNumber&g

  • How to create wizard for a custom mainenance view/view cluster 10-11

    Hi Experts, I have created 5 custom maintenance view and have maintained all the views sequencially and have made the first mainenance view as the start view & header entry and all other views are child or subview of the header view in a custom view

  • Form Letter Report - How To Format Date and Number Hidden Fields 11-30

    Hi Is it possible to format date and number fields in a form letter report. This case were Paper Design shows fields as $<hire_date>. The examples in reference book only print character values which do not require formatting. I cannot determine how

  • How to see data for particular date from a alert log file 10-11

    Hi Experts, I would like to know how can i see data for a particular date from alert_db.log in unix environment. I'm suing 0racle 9i in unix Right now i'm using tail -500 alert_db.log>alert.txt then view the whole thing. But is there any easier way t

  • How to extract data for particular two members of same dimension. 10-11

    As per the requirement i need to export data for certain members of a dimension. Lets say we need data for two account members A and B which is in in Account dimension only but is not a direct children. I need the data for all the available years too

  • How to fetch data for a struture from a cluster table 10-11

    How can I fetch data for a struture, from a cluster table, based on the name of the structure?Hi, In order to read from Cluster DB Table use the following statement: Syntax IMPORT <f1> [ TO  < g1 > ] <f2> [TO < g2 >] ... FROM DATAB

  • How to change date for Compensation Package Offer (IT0706) 10-11

    I try to change date for an existing record in IT0706 to a later date, however system prompted "The compensation package was already activated. It can not be changed" As I checked, the record status is "Activated". Can anybody help to

  • How to select data for nested object (Object based on another objects) 10-11

    Hi, I have written the following code, but I am not able to fetch data as I fetch from normal table, Plz help. Following is the sample code - CREATE TYPE A_OBJ IS OBJECT ( A_NAME VARCHAR2 (100), A_DESC VARCHAR2 (100) CREATE TYPE A_TAB IS TABLE OF A_O

  • Bapi BAPI_REQUISITION_CREATE : how to populate data for sevices tab 10-11

    Hi all, I am creating a purchase requisition through bapi .I am using  bapi BAPI_REQUISITION_CREATE For creating purchase requisition. The bapi is  creating PR. I need to add item level services details also through bapi.i am Using structure BAPIESLL