I have a query subject Allocated Budget at Activity Level.
The grain of this query subject is Dept-Section, Fiscal Year, and Activity Type.
I want to add a measure <Total Allocated Fiscal Year Section Budget> to this query subject. This measure is suppose to show the total sum of all the <Allocated Amount> for it's associated Dept-Section and Fiscal Year for each row displayed by this query subject. (Please see attached Image for more context).
I am fairly new to FM and I don't know where to start on this or not sure if this even possible in FM.
If you add For dept-section to the measure's expression do you get what you want?
Yes, If I add Dept-Section and Fiscal Year to the expression.
Another parameter that for can use is report, which gives some flexibility to the expression.
It worked. However when I used report as the parameter it worked but the aggregated value was summing all the rows.
So in my query item expression, I used the dept-section and fiscal year as the parameters instead of report and it gave me the expected results.
Aggregate(Allocated Amount for Dept-Section, Fiscal Year)
Thank you for the help.