Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have a pivot table and one of the expressions calculates the amount in function of the selected quarter, but now i need create another expression whos calculated the accumulated amount till the selected quarter. From this way i can show the amount for the selected quarter and his accumulated amount in case to select the quarter two, for example.
Any idea to solve this issue?
Thanks a lot.
Hi, if you have calendar that relates echa quarter to his year and month you can use something like:
Sum({<Year={$(=Max(Year))}, NumMonth={"<=$(=Max(NunMonth)"}, Quarter=>} Value)
If quearter selected is 'Q2' (months 4 to 6), the max NumMonth will be 6, this expression will sum the values of max year selected, months from 1 to 6, and ignoring selections of Quarter (to ignore the filter of months 4 to 6).
Hi, if you have calendar that relates echa quarter to his year and month you can use something like:
Sum({<Year={$(=Max(Year))}, NumMonth={"<=$(=Max(NunMonth)"}, Quarter=>} Value)
If quearter selected is 'Q2' (months 4 to 6), the max NumMonth will be 6, this expression will sum the values of max year selected, months from 1 to 6, and ignoring selections of Quarter (to ignore the filter of months 4 to 6).
Thank you, this works...¡¡¡