I have a number of reports that I need to build that are basically complex crosstabs using two hierarchies. I can't use the crosstab expert because I need to call out specific values for the rows and columns. I am using a BW query as the data source.
The layout is something like this (with ~35 rows and 14 columns)
Hier A node 1 HierA Node 4
Hier 1 Node A Key Figure Key Figure
Hier 1 Node E Key Figure Key Figure
I can isolate the nodes for the rows by using a string variable on node name and the using a an if then formula for each row (if string var = node name then node name else null) and then creating a group on each formula and formatting it to suppress if the value is null.
What I can't figure out is how to get the rows to function. I was hoping to have one formula per column that takes the key figure and filters it by the column node id.
I know I can do this in the BW report but I was hoping to be able to figure out how to use crystal to do this.
Thanks in advance for any help,