Skip to Content
0
Feb 10, 2010 at 07:51 PM

"restricted key figure" type structure in Cyrstal

18 Views

hi,

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,

Andy