Forum Discussion
Cumulative Sum on Text Field
Hi, I am trying to present a cumulative sum by priority and project with the two being a concatenated field in a separate table. Example. (Priority Initiative) 1-Warehouse 2-Field 3-Retail 1...
Anonymous
Please check the attached file:Running Total = CALCULATE( [Total Sales], 'Sales Table'[Priortiy] <= MAX( 'Priority Table'[Priority] ), ALLSELECTED( 'Priority Table' ) )
https://drive.google.com/file/d/1k1M3yCb-4z1e_mF0hAT28SpeY3vdrX2P/view?usp=drive_link
Hi, if you look at Team B, there is 592 for one priority and one for a second one. I would expect the cumulative to be 592 until the next one kicks in to make it 1192. I need this to work with text though.
Hi,
the shared file is different and does not reflect the number as you mentioned please share the file again. Create sample data and remove sensitive information.