Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have filters like empno,enmae,deptno.
in pivot table i need to show any one above fileter as dimension.
if you select any one of fileter then that related fileter data should be populated in pivot table.
For example if you select empno then empno should be displayed in pivot table as dimension. like that for ename,deptno also.
how can i write condition in pivot table??
Hi,
In dimension tab > Enable Condition..
You can write condition like : getfieldselection(ename) > 0 for ename dimension..
for deptno : getfieldselection(deptno)>0...
and so on..
HTH
Sushil
You may create a cyclic group with empno,enmae,deptno as fields and use this group as dimension in your pivot table.
ABD,
has given the way to move you can use getselection () function for this filters and then call it in a calculated dimension in pivot table
HI sanjeev ,
it seems you need info about ad-hoc reporting ,
please find the attachment
Thanks
sasi