Need Excel pivot table independent columns and no sub levels

Experts: Need an help - i want the excel pivot table to show each logically independent columns next to each other instead of sub level/nested.

I can surely create multiple pivot table but would be ending up having 10+. So is it possible and if yes how?

(tried google and videos but no help, so finally writing a post)

Image of how i want it to look is here : Need Excel pivot table independent columns and no sub levels

Added a sample sheet and the pivot table that i get and how i want it to be :)

Replay

I believe you are looking for the report layout settings.Choose something other than "Compact" and you should meet your goal. "No sub-levels" can be obtained by clicking Subtotals and Grand Totals to the left of Report Layout Need Excel pivot table independent columns and no sub levels

Category: microsoft excel Time: 2016-07-30 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.135 (s). 12 q(s)