Nested variables are not working in StraightTable (Without selecting any value)

[#1]

Hi All,

I am using approximately 50 variables in my application.One variable is dependent on the other one. When a value is selected,the reult is displayed propely(Chart/Table).But I need to diaplay the data in a table without selecting any value.

Any idea how to achieve this? Thanks

[deepakk]

hi,

As per my understanding , the variable concept will not work. Because variable can store only single value.

Hence when you write an expression inside variable, it summarize the value and stores in it. Hence when you are selecting the certain values , it again summarize the data and store inside that.

Data   Amt

A        10

B         20

C         20

eg: Variable1 = Sum(Amt) . Variable1= 50

if variable used  inside pivot table

A      50

B      50

C      50

And when you select A . It will store A= 10

A    10.

I hope you are clear with the issue.

If you can attach some sample, we can try out other alternative methods.

Deepak

[#3]

Yes Deepak you are correct. Now can understand the issue in my application. Thanks Deepak.