Dashboard Help

[#1]

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

[its_anandrjs]

Yes you can create a straight table for this and with different formulas with different expression do you have sample data for this.

[#3]

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

[vijetas42]

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