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

Transforming row values as columns

system_migrated

Hi,
I have table that return values like below.

Employee Id| Questions | Answer

Find more posts tagged with

Comments

mwilliams

Hi Giri,

This looks like a perfect place for a crosstab. You'd just need to create a dataCube with Employee and Question as the dimensions, then you'd have answer as the measure. Add a crosstab to your design and drag over the fields to their correct cell from the dataCube and you should have it. Let me know if you have questions.

Migrateduser

Thanks Michael, it worked.
-Giri

mwilliams

Giri,

Excellent! Glad to help. Let us know whenever you have questions!

Giri

Hi michael,

Currently Questions are displayed in random order, though query produces always in same order.
How can I order/sort "Question" Dimension to always display in sorted order "question1,question2,question3".

Br,
Giri

mwilliams

Giri,

You could add a computed column that assigns a numerical value for which question it is, then add that as an attribute for the dimension you're sorting, then add a sort on the crosstab on that group by that column.

Giri

Hi Michael,

Thanks a lot, its worked.

Br,
Giri

mwilliams

Giri,

Not a problem. Glad to help. Let us know whenever you have questions!