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; } } }

Cross tab configuration issue

SheepK

Hello,

I'm designing a report containing a cross tab (displaying orders informations).

My problem is : I have a lot of data (about 50 columns) to display on each row of my cross tab, but I don't want this data to be used as dimensions.

I have : one data field set as column, one data field set as row, and on data field to be summarized (basic cross tab).

But how could I display, for each row of my cross tab, informations about each order (client, date, price....) without putting them as dimensions (I don't want to regroup by client, date...).

Let me know if my request is not clear...

Thanks.

Find more posts tagged with

Comments

mwilliams

Hi SheepK,

I'm not sure I'm quite understanding. Do you think you could show an example of what you'd like your crosstab to be like in here?

SheepK

Hi mwilliams,

Attached : example_result.jpg

In red, you have a typical result from a cross tab. Left to the red area, other data, that I wan to link to my crosstab.

Meanwhile, I have another question, about the column headers (product 1, 2... in my example). I managed to set a static group level : Data was {1, 2, 3...} which I transformed into {Product 1, Product 2, Product 3....}

My problem is : How can I force the display of all products (all columns) even if there is no data for product 2 for instance? (no data in the crosstab summary).

Thanks.