Paginated report Expression column sum() Grand Total

[ldupont]

HI All

I' am working on a Paginated report below , and I would like make a Grand Total ( yellow ) on the expression line 

could you please help me ? Table created in matrix winzard

Many thanks 

loic 

[v-henryk-mstf]

Hi @ldupont ,

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.  link

like below:

=Sum(Fields!LineTotal.Value, "Order")  
' or   
=Sum(CDbl(Fields!LineTotal.Value), "Order")

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

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]

Hi v-henryk-mstf

Many thanks for your answer , I tried to apply your process but it doesn't works , I think I'm using it wrong

1- A rename the line by [wfline] = percentage calculated by line

2- I tried to insert your expression above, and I think that's where I went wrong.

 "Sum(Fields!wfLine.Value, "Order")"what to put in place of order?