Using identifiers and modifiers

[#1]

Hi,

I am working with a sales report and I would need to show not only period and YTD figures but also full year figures.

What kind of set analysis I would need to write to be able to show full year figures? I would need to somehow be able to ignore period selection but include the year selection.

so below is simple example

Period	Value
1	10
2	10
3	10
4	10
5	10
6	10
7	10
8	10
9	10
10	10
11	10
12	10

So let's assume now it is period 5. My report should show periodic value 10, YTD value 50 and full year figure 120. How can I get that 120? it doesn't work with identifier full set 1, because then I would ignore all selections done and I would get data from previous years also. How to write: I want sum of seleceted year and ignore month selection?

Thanks

Regards

Janne

[Anonymous]

If you just want to ignore period in current selection you can simply write in modifier

{$<period = ''>Value}.so it ignore period filter.

Thanks & Regards

Kiran Kokade

[jvitantonio]

Hi, try this:

1) sum( {< Period = {"$(=max(Period))"}    >} Value)   --> current period

2) sum( {< Period = {" <=$(=max(Period))"}    >} Value)   --> YTD

3) sum(  Value) for ALL periods. If you have different years then try:

sum( {< Period = , Year = {"$(=max(Year))"} >} Value)

Thanks,

JV

[#4]

Hi and thanks!

I think you are showing here the simple solution that I am looking for. However, it doesn't work

I have now following script:

sum({$<Period=''>[Value]})

This doesn't work. I know I may have a stupid error there but I can't make this work

Thanks

Regards

Janne

[jvitantonio · Accepted solution]

The right syntax is:

sum({$<Period= >} [Value] )

JV

[#6]

That is the right solution! many thanks!

[Anonymous]

Hi Janne,

don't put any thing after = sign

try this.

sum({$<Period=>[Value]})

Thanks & Regards,

Kiran Kokade

[sasikanth]

Hi janne

try some thing like

sum({< period ={"$(=max(period))"}>} value)  --> for current Period

sum( {< period ={"<=$(=max(period))"}>} value)   --> For YTD

sum({<period= >} value)      -----> For total sum irrespetive of the Period