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.
[Fiscal - Flag Current Date]='Y'
[Amount - Ordered USD])
[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?