Pivot Drill Down stop at the level before null level but dosen’t exlcude the amt in the grand total

[Tanviseth26]

Hi,

In qliksense pivot table is there any way to stop Drill Down at the level before null level but dosen’t exlcude the amont in the grand total?

[Clever_Anjos]

Could you elaborate a bit more about your question? not so sure I´m getting your problem

[Tanviseth26]

Hi Cuv,

I am talking about the ragged hierarchy where some data will be missing. I want to plot that data in a pivot table where if there will be any level missing , that should not be shown in the table but the value w.r.t that particualar level should be added to the total above it.