Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to add a new value in an existing dimension, I initially have this.
I want to have an extra Bar called group avg in all the sales column.
Please see the attached qvw to understand the situation better and I am source the way I have it in the back end.
One possible solution-way attached.
One possible solution-way attached.
Another option is to use CrossTable Load like this
Sale:
CrossTable(Sale, Value)
LOAD * INLINE [
Groups, Sale1, Sale2, Sale3, Sale4, Sale5
Group1, 0.79759424, 0.09878233, 0.274495397, 0.283752506, 0.077262074
Group2, 0.572974879, 0.037239144, 0.021465945, 0.838789364, 0.160991477
Group3, 0.750333678, 0.204238937, 0.239284092, 0.631995441, 0.698577191
Group4, 0.751788678, 0.073845562, 0.418150331, 0.338250451, 0.611715877
];
And then add an Island Table like this
Dim:
LOAD * Inline [
Dim
1
2
];
Dimension
Sale
=Pick(Dim, Groups, 'Group Avg')
Expression
=Pick(Dim, Sum(Value), Avg(Value))
Thanks,
I am pleased. tresesco
stalwar1
Welcome back, it's been a while since I saw you active on community.