Sub Total

[subbareddykm]

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.

Thankx in Adv

[Anil_Babu_Samineni]

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

[Kushal_Chawda]

see the attached

edit: changed the expression to match grand total

[subbareddykm]

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.

Thankx in adv

[subbareddykm]

Is it possible to achieve ?

[subbareddykm]

This is the output format .

[nagarjuna_kotha]

I guess, technically it is not possible.

-Nagarjun

[Anil_Babu_Samineni]

1) Simple remove the Dim

2) Like this

[subbareddykm]

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

is it possible?

[Anil_Babu_Samineni]

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