Klipfolio states that 'All table columns must contain the same number of items and be aligned across rows' for a drill down table to aggregate up. Is there a way around this as I have a data set with an uneven number of items. Seems like a fairly major limitation for a common dataset structure?
I have three levels of drill down and have tried to concatenate the columns using a lookup to match against but this has not worked. I can't think of another way to do it.
Any help would be much appreciated.