Skip to Content
Jan 31, 2014 at 09:09 PM

How to create a Fixed Column Cross Tab?


I am trying to create a Cross Tab Reports that has 5 fixed columns (Month, Prior Month, YTD, Prior YTD, YTD Diff)

I would a Team Member Group and a Clients Row.

It would look something like this:

The numerical values you see would be 5 separate Formula fields calculated from my dataset.

I know how to get the Team Member and Clients to correctly be displayed but I am having difficulty getting the columns working.

The column "headings" would need to be static. It is the client data that is dynamic.

I would appreciate any thoughts or ideas.

Thank you in advance.


Capture.PNG (8.9 kB)