Forum Discussion
Need help: Pivot table from data model cannot use Timeline filter.
To my knowledge there is no such setting. Could you please check if attached works in your environment, that's exactly the same sample.
To my knowledge there is no such setting. Could you please check if attached works in your environment, that's exactly the same sample.
SergeiBaklan
Thank you very much for your file 🙂 It works as photo you attached.
So, I tried to do it again by create a new excel file. The result is no problem on timeline filter. \( ^ ^)/
I don't know why it works now. But I noticed that when I drag "date" to the "Row" or "Column" of Field List in Pivot table fields, It automatically create "Date (Month)" for me but I deselected it. (Last time there was no "Date (Month)" automatically created)
Thank you very much for your help. _/\_
You may disable automating grouping in settings, i.e. creating Date (Month), etc.
However, it costs practically nothing. Never know when such columns could be needed.