Is there any difference between Pivot table and Subtotal?
vijeesh V R (CA Final) (91 Points)
15 March 2012
CA Anand V Kabra
(Author Teacher Mentor)
(584 Points)
Replied 06 December 2012
Originally posted by : vijeesh V R | ||
Is there any difference between Pivot table and Subtotal? Please clarify |
yes, ofcourse.
in pivote one is able arange data as he want
&
subtotal is useful when you want SUM of filtered data n that will change every time you change the filter.