Hi there,
I fail to create a report that returns all non-empty intersections of 4 dimensions.
I use overlapping dynaranges and refer to the outer dynarange as variable in the data filter as shown below:
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.32.15 PM.png]
Note: Each
- F7:J7 cells contain PALO.DATA formulas
- All 4 dynarange expands until the last column (Column J: Billable Hours)
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.40.10 PM.png]
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.39.51 PM.png]
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.40.22 PM.png]
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.40.30 PM.png]
Outermost dynarange (Activity):
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.22.17 PM.png]
Second dynarange (Date):
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.35.04 PM.png]
Last dynarange (Phase):
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.37.30 PM.png]
Yet, what results is no row although there are data at those intersections.
Any suggestion what I am doing wrong?
Thanks
Regis
I fail to create a report that returns all non-empty intersections of 4 dimensions.
I use overlapping dynaranges and refer to the outer dynarange as variable in the data filter as shown below:
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.32.15 PM.png]
Note: Each
- F7:J7 cells contain PALO.DATA formulas
- All 4 dynarange expands until the last column (Column J: Billable Hours)
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.40.10 PM.png]
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.39.51 PM.png]
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.40.22 PM.png]
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.40.30 PM.png]
Outermost dynarange (Activity):
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.22.17 PM.png]
Second dynarange (Date):
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.35.04 PM.png]
Last dynarange (Phase):
[Blocked Image: http://www.lightstream.asia/temp/Screen Shot 2016-01-08 at 12.37.30 PM.png]
Yet, what results is no row although there are data at those intersections.
Any suggestion what I am doing wrong?
Thanks
Regis