I have closing date. I also have a measure called commitment amount. User will choose a date from filter / parameter. Based on that date all commitment amount should be aggregated.
What is the best way ?
Are you looking for this
sum(if closing date <= [parameter date] then [commitment amount] end)
Try with running total calculation
Below image for Normal calculation:-
Below image is for Running total calculation:-
Click on SUM(Sales) like below Image
Please let me know if you have more question on this.
Please mark correct and Helpful if it works for you.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...