Passing variable in Pivot table

[krishna20]

Hi Friends,

Is it possible to pass a variable in pivot table.My requirement is I'm having a year field CL_Year.

I need to give input value in the input box by creating variable and i'm having pivot table which is having dimension CL_year and CL_TW_Year .

For Eg;

When i give input value as 1990 in the input box, the data of 1990 could be shown in pivot table.

I know  this process is possible in straight table. How could be this done in pivot table?

Regards

Krishna

[krishna20]

Hi Friends,

Any Idea ?!!

[Anonymous]

Not clear, sorry...

[Anonymous]

Hi ,

First you create a variable vYear

Then create a input box and pass that variable to inputbox

Create a table and add an expressiion using variable .

ex: sum( {$<Year = {$(#vYear)}>} Sales ).

hope this will help you

Thanks

[krishna20]

Hi ,

My requirement is I need to pass a year filed in the input box.

Ex:

FROM Year [Input Box]   To Year [Input Box]

When inputs given in this input boxes.

The pivot table data need to shown between those years.

[jagan]

Hi Krishna,

Assign a variable to the Input box and use the below expression in the pivot table

variable Name = vInputYear

Sum( {$<CL_Year= {$(=vInputYear)}>} Sales )

Regards,

Jagan.

[hariprasadqv]

Fallow Jagan's View/