subtotal in pivot table

[kunkumnaveen]

Hello All

i am trying to create a pivot table with subtotals in it ,i manage to get total by enabling the  check box show partial sum ,now i am trying to get subtotals for a dimension(country) please find the attachment(sheet2)

thanks in advance

naveen

[#2]

Hi ,

Do you want to see the total like pic ?

[mambi]

you can use this :  sum(TOTAL <Country> Sales)

[settu_periasamy]

Hope you already checked the 'Partial Sum' for Country Dimension also.

In your attachment, Already shows the Country based Total in the Pivot Table.

If you want the "Grand Total" On Top, Just check 'Subtotals on Top' in the presentation Tab.

[#5]

The employee details table is currently showing subtotals by country??

[kunkumnaveen]

Hello senthil thanks for making time and replying to my query ,yes i trying to make replica of those sheets by using the same data and same objects

[kunkumnaveen]

Hello Adam,the  attached document was my task i need too create replica of that thankyou