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

Avoid Group in Crosstab

severinmueller

Hello Community I am trying to create a report listing all the installations horizontally and the necessary data vertically. I have three groups on the left side (main category, category, function) and the data for each installation should be listed below the installation. The attached screenshot will give you an idea of what I mean. The purpose of this report is to display the products with the same function on the same row.My question is: In the third column from the left (function), the data seems to be grouped. I need to resolve this group, so each entry is displayed regardless of whether it appears multiple times. Everything else works perfectly fine, so is there a way I can have every function_name displayed even if there are muptiple entries? Thanks a lot. Kind regards Severin

Find more posts tagged with

Comments

Hans_vd

Add a computed column to your dataset, choose runningcount as the aggregation.Make it a dimension in your data cube and it to the left side dimensions of the crosstab.Finally make the new row dimension invisible by setting the width to zero. That should do the trick

severinmueller

Hello Thanks for the reply, it tried this right away. The problem now is the link between the respective rows. Before the running count, products with the same label were displayed on the same row, because they had the same function. Let me try to explain: Please take a look at the screenshot. You will see 4 "Blocks" (The colored ones, called T-DELPONTE, BLACK-PEARL, etc). Each of those blocks has 4 columns, Product Brand, Product Type, Product Label and Serial Number. The purpose of the report is to compare those Blocks that have the same product brand and product type. //CORRECTION: I need to display the data with the same function_name. The problem is, that the same function name can occur multiple times, becasue e.g. I have three products with the same function. I need each of those productis listed regardless of whether the function is the same. // END CORRECTION Since the amount of blocks is dynamic (could be 2, could be 20) I think I need to do this in a cross tab. Any hints?

Hans_vd

I see.I should have read your question more carefully. Forget the runningcount. Don't you have a "product ID" or something or some other attribute that makes the "Product Label" unique? So you can add that to the product dimension?

severinmueller

Not your fault, I actually this might help

I have the FUNCTION_ID that is unique. The problem is, as i stated, that this is automatically being grouped. I would like to avoid that.

severinmueller

Anyone? May a more simple explanation of what I'm trying to do here. I need a table that displays- the Main Category, Product Category and Product Function on the left side,- followed by "Label, Product Brand, Product Type, Serial Number" - for each installation.- If an installation has e.g. 5 functions, all should be displayed.- Installations that have the same function should display their function on the same row regardless of the product type or label I have attached an excel Sheet with the expected result.maybe the crosstab is not the right selection? Any Input would be appreciated.Thanks Severin