Creating pivot table with drill down feature similar to excel in KNIME.
I’m new to KNIME and I’m trying to redo the tasks in KNIME which I used to do in excel. My question is that how to create a pivot table similar to excel, where you can have expanded rows and you can drill down to categories? I have created a simple pivot table using pivot node but I need to drill down from top level summary to bottom like we do in excel. Is it possible in KNIME?