Hello All - I'm trying to get a running total each month for a 3-month revenue number.
I then need to be able to have the 3 month revenue show up if filtering on a specific month like the following:
Any help would be greatly appreciated.
Thanks,
Mike
8 answers
Here you go. I am using the Superstore data to get what you need.
Now, to display the values for a selected month only, I created a parameter to list out the month and year and created the below calculated field and added it to the data as seen below.
You can now right-click on the "Hide" value and hide the data and suppress the header.
You should now have the desired output:
Hope this helps.
