I am attempting display only the month of November in these BANS but when I filter out October the values change. If anyone has some insight on what I am missing when displaying this data. I am trying to use Adam McCann's sample of 20-ways-visualize-kpis.
3 answers
The table calculations are expecting data so when you filter, the data isn't there for them. A work-around is to use a tablea calc as a filter, so the data is still there.
Create a calc:
LOOKUP (MIN (Month([Entry])), 0)
Then drag that to filter.
Nick
