Creating a pivot table without dimensions

[MaxSeagull]

Hi,

I am currently transferring QV sheets to QS.

In QV it is a pivot table with no dimensions, the first column is the name of the expression and the second column is the actual value of the expression. It looks like this:

When trying to replicate this in QS, I am forced to use a dimension in pivot tables. I tried using a straight table too, but i can't make it look the same:

How do i solve this?

Thanks in advance

[rbartley]

Hi,

What's stopping you defining A-F as a field, e.g. Expression Name, in the load script and then using this as a dimension in the pivot table?