How can we Move Total in between columns in Pivot Table

[SatyaPaleti]

Hi Folks,

I am using Pivot table and we are caliculating Target for all the columns. Is there any chance to move target in between columns. I mean before to one column

Here is the screenshot for reference and Please find attached file for sample qvw

\

Thanks and Regards,

Satya

[trdandamudi]

Please see the attached and hope this helps:

[SatyaPaleti]

Thanq so much thirumula

[trdandamudi]

You are welcome and please close the thread by marking the correct answer if you think you got the solution, so that someone else can also use this solution if needed.

[Or]

You had me all excited about there being a way to actually do this in a pivoted dimension. It does seem to solve the OP's issue, though, so that's good.