Hello,
I need to display the 50% of the products in this table and the overall column totals.
| Product Sub-Category | Sales | RUNNING_SUM(SUM([Sales])) | SUM([Sales]) / TOTAL(SUM([Sales])) | RUNNING_SUM(SUM([Sales]) / TOTAL(SUM([Sales]))) |
| Office Machines | 131,381.18 | 131,381.18 | 17.51% | 17.51% |
| Tables | 110,544.98 | 241,926.16 | 14.73% | 32.25% |
| Copiers and Fax | 94,935.84 | 336,862.00 | 12.65% | 44.90% |
| Binders and Binder Accessories | 73,799.70 | 410,661.70 | 9.84% | 54.74% |
| Telephones and Communication | 65,317.25 | 475,978.94 | 8.71% | 63.44% |
| Storage & Organization | 64,612.86 | 540,591.80 | 8.61% | 72.06% |
| Office Furnishings | 47,691.86 | 588,283.66 | 6.36% | 78.41% |
I put the calculation of tables in filters and samples the smaller ones to .5 but in the general total of column shows the total of 100% not of 50%.
1 of 1 people found this helpful