Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to know if something is possible through Set Analysis.
Let's take an example:
There is a KPI for all months of the last three years.
We want to display the value for each last month of each year (december 2010, december 2011, november 2012)
To make it easier, let's say that November is stored in the variable "MyMonth"
Can I do something like : sum( {$<Month=12, Year={"<$(=max(Year))"}>} + {$<Month={$(MyMonth)}, Year={$(=max(Year))}>} KPI)
More general, can I use operators this way : sum({$<.....>} + {$<.....>} KPI) ?
If it is possible, what would be the syntax ?
Many thanks
Pierre
HI
Try like this
Year,Month as dimension..
=Sum({<Month={'$(=Max(Month))'}>}KPI) as expression
Hope it helps
Hi,
Thanks for your proposal ! Unfortunately, this is not really what I would like to do.
Basically, I would like to know if it is possible to do something like sum({$<.....>} + {$<.....>} KPI)
It is for instance possible to do sum({1-$} KPI)... but is it possible, in this case, to modify the identifiers ?
Or... Let's take another example...
I would like to display in a graph how many customers (in the active selection) have bought red shoes and green ties.
So the formula would be something like :
count({$<red shoes definition>} + {$<green ties definition>}Customers)
Thanks