Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Hi v-henryk-mstf
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
5 | |
4 | |
2 | |
2 |