powerpivot Calculate with the two filters

**Hassan1977** · 10-12-2016, 08:51 AM

hi All

I am trying to put the sum of a columns into buckets "current" "1-30"..using formulas

Please Login or Register  to view this content.

Aging table is as per below

HTML Code:

so I m getting result 1 when it should be 2

1

HTML Code:

any ideas where it is going wrong please ?

Thanks

**xlnitwit** · 10-13-2016, 02:16 AM

Hi,

Could you provide a sample workbook and clarify which version of Excel / Power Pivot you are using?

**Hassan1977** · 10-14-2016, 04:49 AM

Originally Posted by xlnitwit

Hi,

Could you provide a sample workbook and clarify which version of Excel / Power Pivot you are using?

I have added the = and that seem to have solved the issue

Thanks for your response anyway

Solution

Please Login or Register  to view this content.

Re: powerpivot Calculate with the two filters