Hi Bora, what you said about LOD makes sense; however, I can't figure out why it's not working in my case, see below.
The source data looks like below.
| Category | Date | Org |
| NULL | 6/1/2018 | XYZ |
| NULL | 7/1/2018 | XYZ |
| NULL | 8/1/2018 | XYZ |
| NULL | 9/1/2018 | XYZ |
| A | 6/15/2018 | XYZ |
| A | 8/5/2018 | XYZ |
And I'm trying to create the following table with columns being Month/Year of the Date field and rows being the Org field, along with "Category" field being the filter. Right now, the Month "July 2018" and "September 2018" columns go away when I dis-select NULL from the Category filter. So I created a new date field using this LOD expression: { FIXED [Org], MONTH[Date],YEAR[Date]: MIN[Date] }, hoping using this new date field as columns would ignore the Category filter. But the same thing happens, July 2018 and Sep 2018 columns disappear when Category A is selected.
June 2018 | July 2018 | August 2018 | September 2018
XYZ
Thanks in advance for your help!
Dec 6, 2018 4:07 AM