Hi,
I am compiling data for a number of properties, all of which have both rental & service charge data. In my script I have identified which properties are rental & which are service charge by their references & have created a field called 'Group' which has 2 possible results - rent & service charge & all of this works fine.
What I am now trying to do is gather data in a table - lay-out as below - property is my dimension:
| Property | YearMonth | Jan-14 | Feb-14 | Mar-14 | Apr-14 | May-14 | Jun-14 | Jul-14 | |
| Property A | | | | | | | | | |
| Property B | | | | | | | | | |
| Property C | | | | | | | | | |
| Property D | | | | | | | | | |
| Property E | | | | | | | | | |
| Property F | | | | | | | | | |
| Property G | | | | | | | | | |
| Property H | | | | | | | | | |
| Totals: | | | | | | | | | |
| | | | | | | | | | |
The issue I have is as follows:
- I want to show all properties (A-H) regardless of whether there is data for that month or not (I also want to show all month).
- If in my settings I tick the 'show all values' box on the property dimension I get both rental & service charge properties - i.e. it ignores my selection in my 'Group' field
How do I get around this? Do I need a calculated dimension rather than simply choosing the Property field as my dimension?
Thanks
