RE: Fixed rows

[Chanty4u]

Hi all,

i have a issue in pivot table like

i have a data for customer-group    in that i have category

like  food,expense,cost, like that  what i want is  in food section i have 10 rows so i need after that 10th row   FoodEnd   like that expense end,cost end   like that i need to display.

is there any possibility?

Expected output :

Customer-group

Food

     aa

     bb

     cc

Foodend

Expense

     dd

      ee

       ff

ExpenseEnd

like so on.........

[avinashelite · Accepted solution]

Check this

Custom Labels in Pivot Table

Showing Dynamic "Total Label"