pivot and straight Table

[#1]

Hi,

How to display all the records by using Input box like Top 10, 20,30 ... in straight and pivot table.

Can you please tell me .

Thanks,

MLNR

[PrashantSangle]

Hi,

Create Variable,

then

1) If you are using Straight table then go to Dimension limit

select show only->and insert variable name in front of it.

2) if you are using Pivot table

then in dimension use Calculated dimension and in that use rank()

Regards

[arulsettu]

hi

check this

Calculating TOP 10 VALUES in PIVOT TABLE

[#4]

Hi,

Now i created variable and pass that variable to input box and straight and pivot Table. so i got Top 10,20,30..... like that. along with that i want to display All the records.

How can i achieve this.

Thanks,

MLNR

[#5]

Hi,

Hope you mean to control the Top Records to be listed using Input Box.

Use the Following Steps :

1. Create a Variable.

2. Create an Input Box and assign the Variable to it.

3. Create your Chart as desired.

4. Go to the Dimension Limits Tab in the chart and check the Limits Check Box and the First radio Button -Show Only.

5. Assign your Variable in place of Values.

You can also control the Input Box values to be entered.

Hope it helps !

Cheers !

[#6]

Hi ,

This is ok. I achieved,

to control the Top Records to be listed using Input Box. and  along with that if user wants to display all the records.

what is process for that,

Thanks,

MLNR

[#7]

Hi,

To control the Top Records to be listed using Input Box. and along with that if user wants to display all the records.

what is process for that.

Thanks,

MLNR

[PrashantSangle]

Hi,

Try like

Create One more chart containing all records and using Conditional layout hide or show those report

try condional like

if (isNull(variable),chart1,chart2)

Regards

[#9]

Hi,

Put a condition in the Dimenstions Limit like this ;

if

( vVar='' ,Count({$< Field_Name >}distinct Field_Name ),vVar)

When your Input Box is Null / Empty, this condition will let all the data to pop up in the Chart.

Make sure you uncheck the 'Others'  checkbox.

Hope it helps!

Cheers !