Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi Mayuresh
can you post the qvw ?
Chris
I will do it
Please find qvd and qvw files for above questions.
Sorry Mayuresh
I tried some tips but unable to find a solution
Let me know when you get it
Best regards
Chris
HI,
It is not the solution you wanted but it mimics the format you wanted...
Sean