The pivot won't work on Joined data sources, I tried.
I am trying to make it look like this:
Category MOnth of May
Count of Client where IRed is not null ERed Count of Client where ERed is not null Blue Count of Client where Blue is not null Grey Count of Client Where Grey is not null
Of course this is simplified to give you the idea there are other formulas involved- such as the Fixed LOD as I mentioned in the first post.
The dates are used to group of course.
Any suggestions would be greatly appreciated.
Measure Dates Etc.twbx 4.7 MB