grouping

[#1]

how can we convert this chart

into

[kaushiknsolanki]

Hi,

     You can change the sequence of the dimension.

     In Dimension tab take Terminal on top and then second one should be business.

Regards,

Kaushik Solanki

[#3]

hi

simply take a straight table. then get the desired result. hope this helps you.

[#4]

Thanks, but i tried that it result in

but i want that grand total should be display in the bottom. i.e.634.99  & i will not display 97.68 ,383.55,154.16

Can't we display the chart in same same format as required by user( as mentioned in excel attachment)

[#5]

how?

[#6]

plz reply asap

[#7]

Hi Sweta

Instead of using Pivot Table just click on straight table...

That should do the trick...

[#8]

Dear Shweta,

In the general tab of you pivot select straight table which appears below the pivot. Also looks like in your image you are sorting by terminal. If that is correct go to sort and promote terminal over business. This should give you what you want.

Regards

Rahul

[#9 · Accepted solution]

Yes  !!, I got the solution

Using pivot table

take-terminal as 1st  dimension then  check show partial sum for both terminal and category & for terminal write grand total in label tab and for category write total in label