Hi All,
I need to have a customized grand total in excel. Lets say I have Sales Quantity and Order quantity as two measures and I have city attribute. I need to get the grand total of Order quantity wherever I have a sales quantity. If there is no sales quantity and there is order quantity the grand total of Order quantity should exclude the numbers. Also, I have many cities and in excel we apply filters on rows to select only 5 cities. So my grand total should not show for all cities but it should show only for the selected cities.
Please let me know if you need additional details.
Regards,
Ram
City | Sales Quantity | Order Quantity |
C1 | 100 | 10 |
C2 | 200 | 20 |
C3 | 30 | |
C4 | 40 | |
C5 | 300 | 50 |
Total | 80 |