How to do a weighted average in a Pivot Table that has 3 Total Lines In the Rows?
Hi All,
I've hit a roadblock and looking for some help. Here are the details:
I am using a Vizlib Pivot table
My rows consist of a Category, Brand, and Wholesaler.
My Columns consist of Version (Actual or Forecast), and Weeks
The category, brand, and wholesaler can be collapsed or expanded based on the nature of the pivot table. When subcategory is expanded, the list of brands are displayed. When a brand is expanded, the wholesalers are displayed.
There is a Total line at the subcategory level, brand level, and wholesaler level if everything is completed expanded.
Rather than summing up, I would like the total lines to be the weighted average.
So for example the Total Line for Wholesalers would be the weighted average across the wholesalers (in that expanded brand) for a given week (column). The Total line for Brand would be the weighted average of the various brands (in that expanded catgegory) for a given week. The total line for Category would be the weighted average of the various categories for a given week.
If a weighted average is not possible, then an average would be fine too.
Any help or guidance would be appreciated, especially from @sunny_talwar !
