Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is there a way for me to merge a column as a row?
So for example, in QV, my chart looks something like this
Cloud 2014 Act Cloud 2015 Act Cloud 2016 Act SASS 2014 ACT SASS 2015 ACT SASS 2016 ACT
Revenue
Direct Expenses
Indirect Expenses
Is there a way to make it look like this?
CLOUD SASS
2014 Act 2015 Act 2016 Act 2014 Act 2015 Act 2016 Act
Revenue
Direct Expenses
Indirect Expenses
Like some type of grouping?
You can use a pivot table to create a visualization like this, having two dimensions, one for the CLOUD / SASS grouping, one for the Year Act grouping.
If possible, create your dimension fields in the script, or use calculated / synthetic dimensions.
Can you give an example please?
My columns are expressions.