Adding Custom Dimension

[Anonymous]

Hi All

In attached QV how do I add custom Variance (Q1-14 - Q2-14) column. Here Q1-14, Q2-14 are dimensions

Thanks

[buzzy996]

on expression tab u can create "Q1-14 ,Q2-14 ..etc"and play with rows & columns to move

[Anonymous]

Hi Shiva

I appreciate your reply.

In this case dimensions are not static

[pokassov · Accepted solution]

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:

[Anonymous]

Dear friend

I appreciate your answer, it's really helpful

Thanks