[REPORT BUILDER Help] Nested Subtotal

[slap33]

Hi all,

i start with my example values (with football club) :

Club	Budget	Joueur	Salaire
PSG	100	Ibra	20
PSG	100	Messi	40
PSG	100	Mbappe	50
Bordeaux	10	Pauleta	3
Bordeaux	10	Papin	1
Bordeaux	10	Dugarry	2

Here is my sample data, and this is what i want to get :

My dataset had budget values on each rows. I'd like to deal with those duplicate with such an expression : sum(distinct(Fields!Budget.Value)) but it seems RB can't perform multiple agregations...   😞

One solution could be to create an agregated dataset but i wonder if i will be able to connect/join my 2 datasets together in order to display both values in the same array. I think i won't be able to.

I grouped [Club] as a parent and [Budget] as a child, so the structure of my array seems to be pretty ok. But my sums are still displaying agregated values.

I struggle on expressions trying to find the good one. Any tips ?

Thanks you all

[slap33]

Hi @V-yubandi-msft  

hope i dont bother you with my issue. Could you tell me what you did to get that wonderful output pls ? 🙂

thanks

[V-yubandi-msft]

Hi @slap33 ,

Thank you for reaching out to the Microsoft Fabric Community. We attempted using the standard 'enter data' dataset, and the output is shown in the screenshot below. Could you please confirm your data source, such as SQL or Excel? Additionally, providing your expected output would help us resolve the issue more efficiently. We look forward to your response.

FYI: 

Thanks..

[slap33]

wow this is exactly what i want

for my sample data, i built it in an excel sheet yes

but my real life usecase is a sql source indeed, kinda same issue though (group / sum no duplicate)

how did you perform the trick ?