Re: Calculate Previous Month Value based on Filter Selection
I am reopening this discussion again. I am facing a peculiar problem. When I do the calculation you provided in a text box I get a different number for both current month as well as for previous month. However, when I plot it on a graph either as a table or bar chart I get the exact correct numbers which is there in my excel. Jut to give some more context, the account numbers repeat in a month. Any reason why this is happening? My account number gets linked with other tables. However, that is not causing the problem since the table chart gives me exact numbers but in the text box I get a different number..
I need count(Account Number) every month and not count(distinct Account Number) in the text box. I tried count(Account Number) in the text box calculation, however it doesn't count duplicate values