Sum with Grouping

[VinhDam]

Hi everyone,

I have a simple table like below:

Sales  Aging

$100   1

$200   2

$300   5

$400   9

$500   15

I would like to to perform different sums based on aging, for example, sum of Sales if Aging is between 1 and 2; sum of Sales if Aging is between 2 and 5; or sum of Sales if Aging > 5

How would I construct such a report?

Many thanks for your help.

[itchyeyeballs]

This might help - http://www.powerpivotpro.com/2014/11/new-twist-for-dynamic-segmentation-variable-grain-range-selecti...

[greggyb · Accepted solution]

Are the groups static, or do they need to be dynamic based on a user selection?

If they're static, it's easy. Make a new field (preferably at your data source if you can, else in a query (e.g. in Power Query) before the data is added to the Power Pivot model) with those groups. Then you can just create visualizations against the new field that contains the group.

If they must be dynamic based on user selection, you'll have to give us some more detail on what your expected use case is, and the solution will be a bit more complex.