Forum Discussion
gtamir
Post Patron
Post Patronfilter a summarised table by date
Hi, I have a summarised table based on the transaction table. Then I have a page with visuals using measures based on the summarised table. Now I want to filter the visuals to one month only. Is it...
amitchandak
Super User
Super UserYou can join your summarized table to your Calendar table and filter ?
gtamirPost Patron
Post Patronamitchandak How? there is no common field.
- amitchandak
Does that table has Month, Then use that as a filter. I think I am confused now. Please explain the issue with an example.
- gtamir
All the visuals are based on measures
- amitchandak
Have you created a separate measure table and referring to that. This means a dummy table with the only measure.
In that, case your measures will respond to the filter of the tables they belong too.
If you have created a summarized table without a date or month, then you have to create it with a date. You can take month start date to group data at month level and join it with the date table.