Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created dashboard based on emp data.
it contains empno,ename,sal fields and i have created empno as filter.
i have creted stright table for represent salary based on ename.
But i need to calculate setanalysis if i select filter as empno then i need to sum of salary on table otherwise i need to show based on ename how can i place in expression plesae give me example?
try this
sum({<empname=}>}sales)
May be like this
Regards
ASHFAQ
Hi,
Sum({<ename=}>} sal) ----it will give which u select the empno that sales only.
Sum({<empno=}>} sal) ----it will give which u select the ename that sales only.
Sum({<ename={'*'}>} sal) ----it will give all ename that sales only.
Sum({<empno={'*'}>} sal) ----it will give all empno that sales only.