Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
This may be very simple and I am overthinking this,
I have a measure, which is a sum and has some set analysis which generates that measure. However, I do not want an aggregated view, which means I have to use this as a Dimension instead of a Sum of the measure so I can see each record instead of a aggregated view of that record.
How can I add the set analysis into the dimension so I have that view?
Sum({$<APEYearAndMonth={">=$(=vStartDate)<=$(=vPriorAPE)"}, DateType={'FKCDate'},SProfitCentre= {'GB00PG002','GB00PG008'}>}Payment)
I want a record of each payment, not aggregated but with the above criteria, where the APEYearandMonth = those values and the DateType and SProfitCentre = those values? Thanks in advance
You could keep this expression by adding an appropriate atomic dimension(s) to your table - maybe a PaymentID.
- Marcus