Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having trouble showing data for the previous year in a Pivot Table.
I have an expression:
sum([staff member])
with Dimensions:
Region, Dept, Period
and wanted to add another expression as:
sum(year={<year-1>} [staff members])
have tried many different options but none seems to work. I'm using a Pivot Table.
Try: sum({<year={'$(=only(year)-1)'>} [staff members]).
Note, you can't also use year as a dimension in your pivot chart and you need to select one year.
This one is alsno not working.
Should I calculate totals in my script? Or should I change to another chart type from Pivot Chart ?
Any suggestions ?
Hi try this,
sum({<year={$(=Max(year)-1)}>}[staff members])