How to display the Last week values in Pivot table

[#1]

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

[swuehl]

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

[Oleg_Troyansky]

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.