Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can we calculate cumulative value of amount w.r.t. Location on monthwise using set analysis.
I need to do it by using set analysis only.
I have a variable mindate .
For data and sample output , please refer the attached spreadsheet.
Regards,
Veman Reddy
A set is only calculated once for the entire chart, not once per row in your chart. So if I understood your question, it is not possible to do a cumulative value with only set analysis. In your example, though, it could be as simple as putting a checkmark next to full accumulation on the expressions tab for the second expression.
Hi John,
Thanks for your response and also your help in this community.
But I need to do it in pivot table and need to display current quarter information of all locations but It should consider the cumulative of all previous months without displaying in the chart.
Thanks & Regards,
Veman Reddy