Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having trouble applying variables across dimensions within a chart.
I have attached an example that has a sample set of data. Essentially I want to apply a percentage to the count (based on product and range) whilst then showing the result by month and product.
I have tried this within an if statement and using input boxes, however I don't seem to be able to get it to work.
I would be grateful for any advise on this.
Many thanks
Hi,
try using this expression:
=sum(
aggr(
if(Product = 'A',
if(Range = '6 - 10', (( count(Case) / 100)* $(A Range 6-10)),
if(Range = '11 - 20', ((count(Case) / 100)* $(A Range 11 - 20)),
if(Range = '21 - 30', ((count(Case) / 100)* $(A Range 21-30)), 0))) , 0)
+
if (Product = 'B',
if(Range = '6 - 10', ((count(Case) / 100)* $(Other 6-10)), 0) ,0)
, Range, Product, Month)
)
Hope this helps you.
Regards,
Fernando
Hi,
try using this expression:
=sum(
aggr(
if(Product = 'A',
if(Range = '6 - 10', (( count(Case) / 100)* $(A Range 6-10)),
if(Range = '11 - 20', ((count(Case) / 100)* $(A Range 11 - 20)),
if(Range = '21 - 30', ((count(Case) / 100)* $(A Range 21-30)), 0))) , 0)
+
if (Product = 'B',
if(Range = '6 - 10', ((count(Case) / 100)* $(Other 6-10)), 0) ,0)
, Range, Product, Month)
)
Hope this helps you.
Regards,
Fernando
Fernando,
I just checked this out; it works perfectly. Thankyou very much for your help on this one.
Many thanks