¿is there any way to show the total of each period below of each period?
If you have latest qv version, you might be able to see :
in presentation tab of the chart properties. Enable 'Stll Show Total on Top'.
Find attached a solution for your problem.
i am sorry i mean below each period i want the total of the period
replace Date dimension with a calculated Dimension
=AGGR(Date & chr(10) &sum(Sales) , Date)
you can also add Num() formatting
=AGGR(Date & chr(10) &NUM(sum(Sales),'#,###') , Date)
i don´t see the total by date.
i attach the file with the dimension calculated.
Please find the attached file. Hope it helps
Your calculated dimension should be below
=AGGR(Date & chr(10) &num(sum(Sales),'#.##0') , Date)
i don´t see the totals
the Code is not working in your copy? I am able to view in which I have attached.
What about this ?
¿can you send me the file?
Retrieving data ...