Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
¿is there any way to show the total of each period below of each period?
thank you
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'.
Hi Pablo,
Find attached a solution for your problem.
Regards
Youseef
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)
Hello,
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 ?