Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
didierodayo
Partner - Creator III
Partner - Creator III

Total with dimension value

Hello,

in the sample document attached below, I am trying to set the Total row as  (Total A) and Total (B) . basically I need the dimension value added in front of the total.

Any suggestion for achieving this is appreciated.

Thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable

Another workaround...

Dimension_in_subtotal_pivot.PNG

View solution in original post

9 Replies
Anil_Babu_Samineni

I don't think so whether we have feature in it. Let's see whether some one offer you because. If it is one expression then it could possible. Let them back to thread.

stalwar1marcus_sommerokg

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

May be a work around

Capture.PNG

MK_QSL
MVP
MVP

Another solution..

But with date selection this will not respond.. so have to do some work around for that.

annafuksa1
Creator III
Creator III

you will need to change a model to achieve that

MK_QSL
MVP
MVP

Here we go!

Anonymous
Not applicable

Another workaround...

Dimension_in_subtotal_pivot.PNG

didierodayo
Partner - Creator III
Partner - Creator III
Author

Thanks all,

I will try all the options you suggested and get back with what worked for me.

Cheers

Kushal_Chawda

PFA.

may be my solution will match from one of the solution given above as I have not seen what other replied

didierodayo
Partner - Creator III
Partner - Creator III
Author

All the steps suggested arrive at the end result I just used what worked well for my data.

thanks everyone.