Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table that I need to calculate based on the dimension on the left of the table. The two dimensions are from an inline load I am doing called "Grouping". Below is the table:
I need the measuers for Orders(000), Sales(000) and PTQ calculate based on the dimension being MTD or Prior Day. Below is the analyisis I was using.
if(Grouping='MTD',
Sum({<
[Fiscal - Flag Current Date]='Y'
>}
[Amount - Ordered USD])
,
Sum({<
[Fiscal - Flag Current PTD]='Y'
>}
[Amount - Ordered USD]))
However, this is just returning zeros. How can I get this measure to identify and consider the dimension in the corresponding column?
Thanks!
You are missing the curly brackets in the set statements: {'Y'}
You are missing the curly brackets in the set statements: {'Y'}