Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone!
How can i divide my measures by 2 big columns?
So i got this:
And i want to sub-heading my measures over with red lines in 2 sub-columns like this:
You might get the grouping from the data model and drag both the Dimenion into the Column part of Pivot. QS will then group both of them and show the the grouped column with a + sign which you can click to see the underlying values (25,30,35....etc)
Screen1:
Screen2:
I can't do like that because my measures self-maked in expressions.
It's possible way only if i make measures in load data script.
Are the columns in the pivot table dynamic i.e. can the value in the series 25 30 35...60 increase further or it will remain the same?
If they remain the same, probably in some way you can use the same expression which calculates the measure value to construct a dimension which retruns string such as "25", "30", "35"....."0","5","10"...etc