How to do and include a group by aggregate measure query item

[Rajeev]

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.

[bus_pass_man]

If  you add For dept-section to the measure's expression do you get what you want?

[Rajeev]

Yes, If I  add Dept-Section and Fiscal Year to the expression.

[bus_pass_man]

Another parameter that for can use is report, which gives some flexibility to the expression.

[Rajeev]

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.