Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Good Evening All, I would like to display the last week values using the Dimention is WEEK and Expression is Sum(Invoicess).
I tried = PEEK(Sum(Invoicess),-1), its not working.
Can any one help me how to this in a pivot table to display the last week Sum(Invoices).
Regards
Joe
Hi Joe,
WEEK is a numerical, right?
I think you could try a set expression like
= sum({<WEEK = {'$(=max(WEEK))'}>} Invoices)
as expression in your pivot table, which should limit your week dimension to last week within your current week selection.
Hope this helps,
Stefan
Unfortunately, Set Analysis won't work here, because Week is also a Chart Dimension. If you need to present sales for a prior week (as opposed to the "current" week) in a chart, you'd have to create an additional table with another Week field and associate the two fields in such a way that the additional week field will represent the "next week" compared to the original week field which is associated with the data. Then, you can create a chart with the new field as a dimension, and it will show Prior week's data based on the association between the fields.
For example:
New Week | Week | Sales |
---|---|---|
2011/02 | 2011/01 | 1000 |
2011/03 | 2011/02 | 2000 |
2011/04 | 2011/03 | 3000 |
This way, Sales for Week 01 can be presented for "New Week" 2011/02 when "New Week" is used as a Dimension.