Loading a Extras Pivot table to initialise multiple rows and columns

[sydney.w.stewart]

What I’m trying to do:
Pre load multiple values for rows and columns to display initially on a pivot table

What I’ve tried and what’s not working:
Tried putting parameters in the rows or column properties of the Pivot using list formats. Just shows a blank Pivot table

Any suggestions welcome

[owen.campbell]

There isn’t enough info here for anyone to help.

We can’t see the data you’re trying to pivot or how it’s added to the component.

We can’t see your code, so we can’t spot any errors or reproduce the problem for ourselves.

[sydney.w.stewart]

Ok thanks for you response. I will a make a simple example and submit details

[sydney.w.stewart]

Here is what I get with the settings shown below

I would like to program the pivot so that we can by default (initially load) set more than one item in columns of rows e.g.

I have tried several ways to get this to happen but not succeeded - Help please. Here is a clone at

Login

[duncan_richards12]

So the issue is that you are adding the list values as a python list in the IDE with the brackets and quotes, but in the IDE you don’t need/can’t use quotes and brackets, but rather you just put the values you want on separate lines in the IDE.

This is basically because the IDE is converting the values to YAML.

[sydney.w.stewart]

Many thanks. I tried everything except that!