Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
see the attached
edit: changed the expression to match grand total
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
Is it possible to achieve ?
This is the output format .
I guess, technically it is not possible.
-Nagarjun
1) Simple remove the Dim
2) Like this
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?