Hi there!
I have a problem with my pivot table:
Lets assume I have the following source for my pivot table:
[...]
Month Type Value Description Category 1 Category 2 January Variable expenses 1,00 Test description Some category So 2,00 Another test description Some category Some other category 3,00 Test description Some category Some other category Revenue 1000,00 Some revenue Rvenue cat Other cat 500,00 Some other revenue Rvenue cat Other cat February Variable expenses 4,00 Test description Some category So 5,00 Another test description Some category Some other category 6,00 Test description Some category Some other category
and so on. If I now try to make a pivot table out of this, excel just evaluate the first row for January, February and so on but does not automatically recognize, that all the other rows (up to February) are also part of January. Its just shown as "empty". The same thing for my "types". Yes - I could now just copy the value of January down till it reaches February and the same for types too but that would make the source extremely confusing and bad formatted. Would look like:
Month Type Value Description Category 1 Category 2 January Variable expenses 1,00 Test description Some category So January Variable expenses 2,00 Another test description Some category Some other category January Variable expenses 3,00 Test description Some category Some other category January Revenue 1000,00 Some revenue Rvenue cat Other cat January Revenue 500,00 Some other revenue Rvenue cat Other cat February Variable expenses 4,00 Test description Some category So February Variable expenses 5,00 Another test description Some category Some other category February Variable expenses 6,00 Test description Some category Some other category
That would work but (as you can see) is not really a solution if you want to keep the data clear.
Is there an option in pivot tables to say excel: please reuse the value you found if there is an empty cell or somethin like this?
Thanks for the answers!
Bookmarks