I have been searching for the answer to this, I must be using the wrong key words. I have a basic powerpivot table summing sales dollar amounts for each sales office/district/region over 1 year (based on individual daily sales orders). I need
to apply a formula to the summed dollar amount, but the formula is only valid at the year level, so it only works on the summed values. How and where can I apply this formula, but still be able to filter my data at the different sales group levels?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.