Here it is:
You need to create a Special Filter here now to filter view but not data
and for January
If this Helps, Pl Mark it Helpful and CORRECT to Close Thread
Special Filter.twbx 2.4 MB
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.
3 Month Sales.twbx 2.3 MB
Hi Hari - thanks for the quick reply. Can you show me what you did for the parameter? I think it have to do with my formatting of dates that this isn't working.
This is what I have for the parameter:
I've tried a lot of different combinations, but it seems to be doing the show/hide off of the actual order date:
is it because something is wrong with my Show/Hide below? I couldn't figure out what you did to get [Month-Year] to come up in your calculation above so tried to mimic it in a different way:
Thanks again Hari - very helpful!!
You are welcome.