Paginated report Expression column sum() Grand Total

Question

HI All&nbsp;I' am working on a Paginated report&nbsp;below , and I would like make a Grand Total ( yellow ) on the expression line&nbsp;could you please help me ?&nbsp;Table created in matrix winzard&nbsp;Many thanks&nbsp;loic&nbsp;&nbsp;&nbsp;

v-henryk-mstf · Answer

Hi&nbsp;ldupont&nbsp;,
&nbsp;
You can name the text boxes for the total lines containing the totals as required and then place the final formula in the desired text box.&nbsp; link
like below:
=Sum(Fields!LineTotal.Value, "Order")  
' or   
=Sum(CDbl(Fields!LineTotal.Value), "Order")
&nbsp;
You can also refer to the following similar solution, I hope it will help you.
Re: Paginated report Expression column sum() Grand... - Microsoft Power BI Community
&nbsp;
If the problem is still not resolved, please point it out. Looking forward to your feedback.
Best Regards,Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ldupont · Answer

Hi&nbsp;v-henryk-mstfMany thanks for your answer , I tried to apply your process but it doesn't works ,&nbsp;I think I'm using it wrong1- A rename the line by [wfline] =&nbsp;percentage calculated by line2-&nbsp;I tried to insert your expression above, and I think that's where I went wrong.&nbsp;"Sum(Fields!wfLine.Value, "Order")"what to put in place of order?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Paginated report Expression column sum() Grand Total

2 Replies

Related content

Paginated Report

Paginated report

Paginated Report headers not repeating

Paginated Reports

Paginated Report Subreport Visibility