Hi all,
Looking to build a dashboard that only shows movement from the previous day, but I would like all selected performances to stay as a row, regardless of whether there was a sale or not. I'm been looking around and cannot find any options to retain "0". Anyone happen to know how?
Thanks!
Loccy
You could add a column, such as "capacity" or "Sales to Date", that you know will always be there.
If Gawain's suggestion doesn't get you there, and if you have a filter limiting the results to orders dated yesterday, remove that filter and instead use a filtered value formula such as
( [Total Ticket Count] , [Days in Order Date = Yesterday] )
Thanks! That did the trick.