#1
|
||||
|
||||
Pivot Table:delete zero values when using calculated objects
Hi, everybody!
In Pivot Table create calculated object. However at its application zero values of fields become visible. How not to display them, but to use calculated object? In PT_object.xls in detail I drew - that turns out (the table at the left, excess values are filled in red) and that it is necessary to receive (the right table) Thanks! P.S. Sorry for my English, i used the Internet translator |
#2
|
||||
|
||||
Friends!
My question is so difficult? Or it has no decision? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Tables - Values divided by Subtotal | Loretti | Excel | 0 | 11-12-2012 02:15 PM |
Inserting a date calculated from a table cell | theMikeD | Word | 2 | 09-11-2012 05:46 PM |
Excel Pivot Table Calculated Field | BertLady | Excel | 0 | 05-21-2012 10:51 AM |
Pivot table help | TishyMouse | Excel | 2 | 04-27-2012 10:19 AM |
add values from different variables with pivot table | andrei | Excel | 2 | 01-19-2012 08:45 AM |