Qlik Sense Pivot

[marcoyukon]

Is is possible to have repeating rows during drill down on a pivot table ?

Example:

From this:

Year	Measure1
Quarter
Month

To This - when expanded all the way to Month:

	Measure Total
2017   2017-01  Jan	220
2017   2017-02  Feb	330

I can't use a tabular table since I need to pivot the data. Or if not possible, is there a setting to allow the pivot to export in this format ?

Another question. Is it possible to remove from the pivot table a dimension or measure in run time.? The only option I could find is to use remote in edit mode and then applying the changes.

Thanks

[OmarBenSalem]

Sure you can,

instead of having as dimensions:

1) Year

2) Quarter

3) Month

It will become:

1) Year

2) Year&'-'&Quarter

3) Year&'-'&Quarter&'-'&Month