Subtotal in streight table

[amayuresh]

Hello,

I am having dataset like Category, commodity and Amount. Single category contains multiple commodities. I have created streight table showing top 10 Categories with sum(Amount), % of Total (% of each category Vs. Grand total of all categories). Also showing Dimension Subtotal (Grand total) and expression subtotal (Total) as showing in below image.

My question: Can I promot Total one step above and Demot Grand total one step below ?

[#2]

Hi Mayuresh

can you post the qvw ?

Chris

[amayuresh]

I will do it

[amayuresh]

Please find qvd and qvw files for above questions.

[#5]

Sorry Mayuresh

I tried some tips but unable to find a solution

Let me know when you get it

Best regards

Chris

[#6]

HI,

It is not the solution you wanted but it mimics the format you wanted...

Sean