Variables in Set analysis

[#1]

Good afternoon community,

I still find it difficult to get variables within set analysis to work.

I am trying to get sum of sales for prior year, and have set up the variable as such.

The outcome of the variable is: "15 | 2014"

I then insert the variable into the below formula, but can't get the syntax right

=NUM(SUM({1<%Date_Period={'=$(vPriorYear'}>}Sessions),'###,###.')

The below formula works ok, and gives a result:

=NUM(SUM({1<%Date_Period={'15 | 2014'}>}Sessions),'###,###.')

Any help will be greatly appreciated, I've gone round in so many circles!!

Thanks,

Simon

Hi all, I've tried what you suggested, but still stuck - I'm not sure if it is the way that I have written the variable, but I can't pinpoint why it won't work for me. Thank you for your advice so far, Simon

[jafari_ervin]

Hi Simon,

Please try to write your variable without '=' and insert it in Double Quotation.

Also added '=' in you variable definition.

=NUM(SUM({1<%Date_Period={"$(vPriorYear)"}>}Sessions),'###,###')

[Anonymous]

Dear Enrique Colomer,

Please explain, how did you created so many charts inside one box !

And also how did you created the different box tabs  " Distribution Annual" "Penetration Por" "........" using the same Table!!

Many Thanks,

[ecolomer]

OK,

I used a CONTAINER in order to group some objects in the same place.

And, in some graphics are TRELLIS