Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hii,
Anyone help me with this:
I have a input Region & City.
and output should be as below in pivot table:
Why do you need them in one column? If its just for appearance, you could use indent mode (Styles tab) in the pivot and remove vertical lines between cells. Set up any partial totals before switching to indent mode.
Thanks for the suggestion.
So, this is the input:
and the output should be:
I am not able to build this pivot table. I want to add Region and city in single column.
Pleas someone help me on this
Following the comments Jonty gave i tried to set something with the Data given, Please check if the attached works