Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to create simple dashboard in tabular format like below:
Any idea from anyone how can I create this format in QV?
Help appreciated.
Total for Day | Cumulative for month | Daily variance to Plan | Cumulative variance to Plan | ||||
Number | % | Number | % | ||||
Daily Sales | |||||||
- Total | 300 | 1000 | -10 | 5% | -32 | -3% | |
- Product 1 | 100 | 1100 | -20 | 7% | -35 | -4% | |
- Product 2 | 100 | 1200 | -30 | 5% | -38 | -5% | |
- Product 3 | 100 | 1300 | -40 | 10% | -40 | -4% | |
Total Amount | |||||||
- Total | 1500 | 1500 | -10 | 5% | -32 | -3% | |
- Product 1 | 500 | 2000 | -20 | 7% | -35 | -4% | |
- Product 2 | 500 | 2500 | -30 | 5% | -38 | -5% | |
- Product 3 | 500 | 3000 | -40 | 10% | -40 | -4% | |
Regards
Mak
Yes you can create a straight table for this and with different formulas with different expression do you have sample data for this.
Hi Anand,
Many thanks for your reply. I am sorry, I don’t have any sample data right now.
But I am very curious to know how can we set expressions displayed in two dimensions like vertical and horizontal as given example?
Regards
Mak
Hi Makarand,
You can use straight table or convert it to cross table as per your requirement and in that you can select expression total in expression tab and also check Totals in first row in presentation tab
I hope this will help you...
Thanks and Regards,
Vijeta Sharma