Announcements
cancel
Showing results for
Did you mean:
Creator II

## Sub Total

Hi All,

By using my data is ,Can we achieve my expected output.

Note :

1.In Sub Total I do not want Bifurcation on Brand , can we able to show same like i have mentioned in output file .

2.Can we able to get in Total as my brand Plant Name ?

3.If its not possible , suggest me alternate methods.

10 Replies

If you are expecting text to vertical, It's not possible. Some work around it will come. But, you need to change script

Re: Vertical Data Text in Pivot Table

No, all subtotal labels for one dimension will have the same value. =Year & 'Total' will only work when only one year is selected/possible. See this post for an alternative:

Try This Expression for Model from Presentation Tab which is Under Label for Totals

=If(Dimensionality() =2, '' & Plant & ':' & Sum([Val 1])+Sum([Val 2])+Sum([Val 3])+Sum([Val 4]))

OR

This for Each Expression like this

=If(Dimensionality() =2, '' & Company & ':' &  Plant & ':' & Sum([Val 1]), sum([Val 1]))

=If(Dimensionality() =2, '' & Company & ':' &  Plant & ':' & Sum([Val 2]), sum([Val 2]))

=If(Dimensionality() =2, '' & Company & ':' &  Plant & ':' & Sum([Val 3]), sum([Val 3]))

=If(Dimensionality() =2, '' & Company & ':' &  Plant & ':' & Sum([Val 4]), sum([Val 4]))

And then check if that suitable. And Company is unnecessary here.

Hope This helps

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

see the attached

edit: changed the expression to match grand total

Creator II
Author

Thankx for ur responce.

there two things.

1. I Dont Want to use Brand in dimentions.

2.Ur output is almost same but I dint want to bifurcate the Brand for Comopany A and C rest i want same like you did.

Creator II
Author

Is it possible to achieve ?

Creator II
Author

This is the output format .

Partner - Specialist II

I guess, technically it is not possible.

-Nagarjun

1) Simple remove the Dim

2) Like this

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
Creator II
Author

I don't Want to bifurcate for for Company A and D only rest i want bifurcation on Brand.

is it possible?

What do you mean bifurcate? Would you describe more. In you WORD format showing A & D. What you don't want to show?

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
Community Browser