I have a straight table with multiple dimensions and measures .how to generate a dimension with numbers(1-100) how to get in ui level.

[#1]

I have a straight table with multiple dimensions and measures .how to generate a dimension with numbers(1-100) how to get in ui level.

[Qrishna]

use rowno() or autonumber function in your script.

Something like below.

load rowno() as ID,

dimension1...

from ----

now you can use that id.

[#3]

i did not get you, what you are exactly looking for

[antoniotiman]

ValueLoop(1,100)

[#5]

Hi Krishna,

   I want only in UI level not in script level

Thanks & Regards

Jammula

[#6]

Hi Antonio,

    Its not working...

Thanks & Regards

Jammula

[Qrishna]

it should work else could you please post sample data.

[#8]

Hi Krishna,

   Please find the attachment...

Thanks & Regards

Jammula

[antoniotiman]

e.g.

Dimension     ValueLoop(1,10)

Expression    If(ValueLoop(1,10)=1,Avg(Total <YourDimension> Sales)

                      If(ValueLoop(1,10)=2,Sum(Total Value)

and so on

similat to ValueLIst('Average','Perormance','Min','Max)

[Qrishna]

See attached.