I am wondering is there is any way to create a multilevel pivot table in Knack? In Excel, for example, I could create a layered pivot that would calculate by both Country and by Category, producing something like below:
I don’t see any way to do the same thing in Knack? has anyone got any great ideas to overcome this, that doesnt require using an external reporting system?