Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ashmitp869
Helper V
Helper V

Help needed to achieve the grand TOTAL correct in paginated Report

Hi,

I have a dataset like below where TotalPrice gets repeated value .

I only need the first Total Price to sum to get my Total amount in Paginated Report.

Expression :

=Sum(IIf(Fields!PayQuantity.Value > 0 , Fields!TotalPrice.Value, 0))

I have use Column Group to show in the table view. But my Total at the end of rows is not correct. Any help 

ashmitp869_1-1726566382165.png

Paginated Report 

ashmitp869_2-1726566676531.png

ashmitp869_3-1726566710879.png

 

The result should be

ashmitp869_4-1726566744204.png

 

4 REPLIES 4
DataGoalsDan
Advocate I
Advocate I

I wonder if you could write an expression to only sum TotalCost where month = January - That way you will only include it once per year?

DataGoalsDan
Advocate I
Advocate I

Hi Ashmitp869

Can you post what your dataset looks like please?  It's hard to understand where those extra rows are coming from.

 

Thanks

Dan

It is because I have multiple TotalCost in different month and year.

 

24	24	Additional labour for continuity	Each	1	437899.08	437899.08	1	437899.08			
7	7	Waste disposal	Tonne	3051.9	388.66	1186151.454	3051.9	1186151.454	5556.36	2024	June
7	7	Waste disposal	Tonne	3051.9	388.66	1186151.454	3051.9	1186151.454	1978.8	2024	July
7	7	Waste disposal	Tonne	3051.9	388.66	1186151.454	3051.9	1186151.454	1272.12	2024	August
7	7	Waste disposal	Tonne	3051.9	388.66	1186151.454	3051.9	1186151.454	9086.4	2024	June
7	7	Waste disposal	Tonne	3051.9	388.66	1186151.454	3051.9	1186151.454	1289.56	2024	May
9	9	Shotcrete	Each	1	1745099.88	1745099.88	1	1270835.88			
9	9	Shotcrete	Each	1	1745099.88	1745099.88	1	1270835.88			
9	9	Shotcrete	Each	1	1745099.88	1745099.88	1	1270835.88			

 

 

ashmitp869_0-1726610958753.png

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.