Forum Discussion
Subtotal based on calculated rows
Hello, I have the below data displayed for 3 consecutive months (NND, NND-1, NND-2). NND for single period calculates as "Availability"/"Client" and results either 0 or 100. Subtotal result is equ...
jordanesqu , can you share formula
You have to try something like
sumx(summarize(Table,Table[Customer_Lv1,Table[Customer], "_1",[Availabilty 3M]),[_1])
Thanks for the tip. I have however more dimensions like region, sales manager, sales rep, material, customer and would like it work flexible depending on selection. in this case sumx did not work for me.