PowerPivot CALCULATE SUM

gavs73

Board Regular
Joined
Apr 22, 2008
Messages
108
Hi, would appreciate any help with this, I'm trying to do a calculate sum if in PowerPivot, example of how it workls in Excel below, but am unsure how to replicate in PowerPivot. Thanks in advance for any help. Gav.
 

Attachments

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,586
Office Version
2019
Platform
Windows
Cannot manipulate data in a picture. Please use XL2BB to upload sample data.
 

gavs73

Board Regular
Joined
Apr 22, 2008
Messages
108
CompanyDateFlagValueTotal
1​
03-May-20​
1​
10​
20​
1​
03-May-20​
1​
10​
20​
1​
10-May-20​
0​
5​
0​
1​
11-May-20​
0​
10​
0​
2​
05-May-20​
1​
10​
30​
2​
06-May-20​
0​
5​
0​
2​
05-May-20​
1​
20​
30​
3​
07-May-20​
0​
10​
0​
3​
08-May-20​
0​
10​
0​
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,586
Office Version
2019
Platform
Windows
You have posted a larger picture and not XL2BB. I cannot determine your formulas from the pictures. Your formula in the first picture cannot be associated with the second posting. Really, help us to help you by providing the necessary information.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,568
Messages
5,469,457
Members
406,653
Latest member
CBeeker

This Week's Hot Topics

Top