Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
In attached QV how do I add custom Variance (Q1-14 - Q2-14) column. Here Q1-14, Q2-14 are dimensions
Thanks
Hi Satish!
If I understood you correctly, you can:
1. change your expression
if(SecondaryDimensionality()=2,Sum(Amt), Sum({$<QtrHead={'$(=MinString(QtrHead))'}>} Amt)-Sum({$<QtrHead={'$(=MaxString(QtrHead))'}>} Amt))
2. set on the Presentation tab "Show Partial Sums"
And then you will be able to see your chart in the following way:
on expression tab u can create "Q1-14 ,Q2-14 ..etc"and play with rows & columns to move
Hi Shiva
I appreciate your reply.
In this case dimensions are not static
Hi Satish!
If I understood you correctly, you can:
1. change your expression
if(SecondaryDimensionality()=2,Sum(Amt), Sum({$<QtrHead={'$(=MinString(QtrHead))'}>} Amt)-Sum({$<QtrHead={'$(=MaxString(QtrHead))'}>} Amt))
2. set on the Presentation tab "Show Partial Sums"
And then you will be able to see your chart in the following way:
Dear friend
I appreciate your answer, it's really helpful
Thanks