Same Formula not working in Bar Chart and #1KPI

[vikas_nandanwar]

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

[luismadriz · Accepted solution]

Hi,

Please review this one: It’s all Aggregations

You could use this: Sum({<[Sales/AOP]={"Sales"}>} [Cts])

I hope this helps,

Cheers,

Luis

[vikas_nandanwar]

Thanks,

this worked

Vikas