-
Pivot table, unable to hide months with no value.
I would like to list all the month actuals first, then month's budget numbers, etc.. (ie. Jan actuals, Feb, Actuals, March Actuals. then Jan Budget, Feb Budget, etc.) Unfortunately I do not see a way to do this without creating a separate column for each of the months. This solution however does not allow me to hide…
-
Apostrophe messing up formula
I have a datarow with an apostrophe, but the apostrophe it messes up my beast mode formula. Any ideas on a workaround for this, I do not have access to change the incoming data.
-
Help Returning The Value for the Latest Date with value
Good afternoon, My company reports a monthly census number for each of its Healthcare centers. I compare these numbers to the budget input. Majority of other metrics, like VISITS, NEW PATIENTS or DROPS can be summed for a year to date number, but Census should not be summed as it would report the latest total each month. I…