help in expression

[ali_hijazi]

got a pivot table with Month as Dimension

my expression is simple sum(Sales)

however for each month I want to display a value representing the sales for previous month

Message was edited by: Ali Hijazi

[jpenuliar]

maybe something like :

=COUNT({<Field_Month={$(=Month(AddMonths(Date(Today()),0)))}>}COUNTER)

addMonths() should be the key

[ali_hijazi]

no cause there might be more than one month displayed

this works if one month is selected

[maleksafa]

can you upload a sample document.?

[agomes1971]

Hi,

if you have for example select the present year - 2014.

You can do like this:

Sum({$<Year={">$(=Year-5)<=$(=Year-1)"}>}Sales)/1000.

Now think like they were months...

Hope it helps

André Gomes

[#6]

Hi,

Try this

sum({<Month={$(=Month(AddMonths(Date(Today()),-1)))}>} Sales)

[ali_hijazi]

check attached sample data in excel

[Gysbert_Wassenaar]

See attached qvw.

[MarcoWedel]

use before(sum(Sales)) or above(sum(Sales))

(supposed there are values for each month in your model)

hope this helps

regards

Marco

[ali_hijazi]

but I need the dimension to be month jan, feb,...