I am using Qlik sense to build a table that contains customers and data associated with the customer. An example of the table is below
Customer Name
Balance
Past Due Amount
x
10
5
y
20
15
z
34
10
I would like to be able to drill down into the past due amount and see what buckets make up that past due amount but I can only figure out how to drill vertically. The table below is what I would like to see if I clicked the past due amount for customer Y.
Customer Name
Past Due days 1-5
Past Due days 6-10
Past Due days 11-15
y
5
5
5
The current drill down only lets me see one "bucket" at a time. Is there anyway to solve this issue? Thanks alot
