Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,,
I am using below formula in bar chart and #1KPI -
if([Sales/AOP]='Sales', Sum([Cts]),0)
My Bar Chart gives me correct representation while #1KPI gives me 0
Why??
Thanks,
Vikas
Hi,
Please review this one: It’s all Aggregations
You could use this: Sum({<[Sales/AOP]={"Sales"}>} [Cts])
I hope this helps,
Cheers,
Luis
Hi,
Please review this one: It’s all Aggregations
You could use this: Sum({<[Sales/AOP]={"Sales"}>} [Cts])
I hope this helps,
Cheers,
Luis
Thanks,
this worked
Vikas