Dimensions as measure in pivot table

[Jsobrinho77]

Hi guys,

I need to create a table with labels above one group of columns, so I'm using the pivot table, the problem is, do I need to include a dimension as a measure in the pivot table? is it possible?

I'm trying to do aggr(only(fieldA),fieldA) but its returning null

[Alan_Slaughter]

Hi  Jose, maybe this will help:

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Visualizations/Pivot....

https://community.qlik.com/t5/New-to-Qlik-Sense/dynamically-select-the-dimensions-of-a-pivot-table/t...