Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to show my Plant straight table box dimention as default value as 6000. how to do that?
Hi,
U want to restrict the plant value to 600
use this
in the script you extract the data ie plant having 600 and give a name for it and use that field in the table box
What does the mean of default? Can you elaborate your requirement.
or Load only dat field and use the where clause
where Plant=600
if(isnull(Plant),6000) is that what you are looking?
if you want the entire to filter on Plant 6000 then use triggers> go to document properties> triggers> on Open > add action>select in field> Plant and value 6000
if you want only in the chart , you can add a calculated dimension like
if(getcurrentselection()=0,if(Plant='6000',Plant),Plant)
I am not getting you. I need to show only Plant field 6000 value in the table.
see in the table box you do not have the option to write any conditions, you need to create a separate field in the script and then use the same in the table box
You load your table and keep only the plant field,
and use where clause
Plant6000:
Load
Plant
From .......................
Where Plant = 6000 as Plant6000;
Hi Avinash,
Still no luck, I need to show only Plant 6000 in the table.
like this I've to create tables for each Plant 6001,6002,6003 .......