Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How would I vary a static step expression based on a Cyclic Dimension displayed.
Cyclic Dimension Values: Product, Country, SalesRep
Expression: sum(Sales).
If the dimension is Product, static step should be 50000
If the dimension is SalesRep, static step should be 100000
If the dimension is Country, static step should be 200000
Thanks in advance for any thoughts.
TD
Hi Tod,
if your group is named ProductSalesRepCountry the expression will be:
=if(GetCurrentField(ProductSalesRepCountry) = 'Product',50000,
if(GetCurrentField(ProductSalesRepCountry) = 'SalesRep',100000,
if(GetCurrentField(ProductSalesRepCountry) = 'Country',200000)))
Hope this helpes!
Stefan
Hi Tod,
if your group is named ProductSalesRepCountry the expression will be:
=if(GetCurrentField(ProductSalesRepCountry) = 'Product',50000,
if(GetCurrentField(ProductSalesRepCountry) = 'SalesRep',100000,
if(GetCurrentField(ProductSalesRepCountry) = 'Country',200000)))
Hope this helpes!
Stefan
THANK YOU ! man - I just could not get that right.