![]() For the monthly subtotals, the figure is to be computed as Average Selling price for every year is to be computed as as Net Amount/(Ttl Bonus + Quantity). The Grand total column should be a a summation of individual subtotals.Ģ. ![]() For the monthly subtotals, the Net Amount and Bonus figure are to computed as a difference of 20 i.e. SUM of quantity of 2005 - SUM of quantity of 2006. The actual requirement is to customise the Subtotal column of the Pivot Table as follows:ġ. There is no complication in creating the Pivot Table described above. ![]() and the summarization function applied to them is SUM. In the Value area section are fields such as Net Amount, Quantity, Bonus etc. For some months, there is data for two years only 20. In the Column labels are two fields, Month and then Year - so in the column labels, for every month, there is data for three years 2005, 20. Visualise a Pivot Table with a few Fields dragged in the Report filter, Row labels and Value Area section.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |