Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
dynamic consolidation by using a subset
Hi,
I need a monthly dynamic consolidation of the Top5 of 40 stores with their growth ratio compared to the last year.
I tried to define a rule which is based on a subset but I don't find the way with the wizard for the right code.
Is it possible to use subsets in a rule and what is the code ?
If not, which workaround may help me ?
Thanks for response.
Axel
If you have Excel you could use the subset to pull the Top 5.
In a hidden (debatable) column you pull the comparison for last year and let Excel calculate the rest.
With a rule you build a new KPI growthrate (for *all* elements) and according to the yield of your subset you pull both the TOP ranking KPI and the "ruled" KPI.
