I am recently working on a problem, where I got the solution in excel please help me replicating it in excel
Firstly I have two columns Date, sales for example.
Now if a user select particular date I should show before and after sales with respect to that date please see the below example
Have you tried putting the IF inside the SUM ? Like ...
SUM(IF [Date} < [Selected Date] then [Sales] else 0 end)
or something close to that will work
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...