Convert into chart

[qv_testing]

Hi Community,   

PFA,

I have used all text boxes, it looks like chart only.

But, when i am making selections, performance very slow.

How to convert chart level..??

Here Revenue, Budget and Variance after that i want to show empty line..

then US and INDIA.

Thanks in Advance...

[sunny_talwar]

Can be done, but don't know if you will be able to achieve any performance benefits

[qv_testing]

HI Sunny,

But here something different, I don't have any dimension.

How can i achieve this ???

[sunny_talwar]

Using synthetic dimension or Island Table. The problem remains that the expressions won't change (causing the same slow down issue)

[Clever_Anjos]

PFA

[Clever_Anjos]

As Sunny said, the only speed performance will be in 3rd column, since it can be rewriten as column(1) + column(2) avoid recalculating

[qv_testing]

Thanks Clever,

Can we show, Empty line.

Like this..

Dimension	2014	2013	Column(1)+Column(2)
REVENUE	24690	-9400	15290
BUDGET	33500	15900	49400
VARIANCE	-8810	-25300	-34110
US	15390	-5800	9590
INDIA	9300	-3600	5700

[sunny_talwar · Accepted solution]

This?

[Clever_Anjos]

Try this

[qv_testing]

Thanks Clever and Sunny,

I have done something... But these two are simple.