Subtotal Calculation

[Former Member]

Is there any way to show the subtotals in front of the section cell, not at the end of section. I have a section within a section. Clients want subtotals in front of both section cells. I have over thirty columns in my report and three of them are measures. I think I should insert a free standing cell in front of the section cell and use the ForEach() function. Do you think it will work:

=[Dimension]ForEach[Measure]

[Former Member]

You can insert the formula inside each section. Make sure that for the top section you are putting in the First section and calculation for the Second section should e in the Second Section.

Use the Formula =Sum ([Measure]) In Section

[Former Member]

Hi Morton,

There's a function specifically for this. Try =sum(measure) In Section