nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Splitting a Cross-Tab into sections

john0shaw · 2014-12-04T16:17:16+00:00

Hello, I am trying to design a report which will split a cross-tab into different sections. I have attached the .XML (datasource.xml). Basically, what I want to do is split it into separate tables based on (so that each ... would be it's…

john0shaw

Hello,
 
I am trying to design a report which will split a cross-tab into different sections. I have attached the .XML (datasource.xml).
 
Basically, what I want to do is split it into separate tables based on <RepeatInterval> (so that each <RepeatInterval> ... </RepeatInterval> would be it's own table that I could perform calculations on).
 
Originally, I tried to create a normal table with two columns, one being set by RepeatInterval, and the other being a cross-tab, but I am unable to find a way to split the data set from the xml into separate sections easily.
 
Any help would be greatly appreciated.
 
Thanks!

Find more posts tagged with

Comments

kclark

You could create multiple datasets from your data source and filter on the TLName to get just what you want. Then you can use each data set to build separate crosstabs. If you need to do this dynamically then I think you'll need to use the Data Engine API to build dynamic data set's and then build your cubes later in script as well.
 
Take a look at <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/822-data-engine-api-to-check-data-set-values/'>this devshare</a> to see how you can build a data set in script.