Forum Discussion

KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
8 years ago
Solved

How do i create a calculated column or measure for totalling up another column as cumulative?

Hi Guys,   This is what I want to do, create another column or measure that calculates Total sales per month per project.  My data is exactly how it is in the table without the "Total Sales" column...
Need Help
shebr's avatar
shebr
Icon for Resolver III rankResolver III
8 years ago

HI KH11NDR

 

Have you tried using the quick measures to try and get your result? Right click on your dataset and select 'Quick Measure'. Select your value and any other options and this may give you what you want.

 

Let us know how you get on.

 

Thanks

 

shebr

KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
8 years ago

I was just trying that, 

 

I selected Running total calculation, Base value as Sales and Field as Project, I was hoping that would have worked, but It's giving the same figures in the month rather than do a runninig total as expected.