How can make selections based on filter for expression

[#1]

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?

[#2]

try this

sum({<empname=}>}sales)

[ashfaq_haseeb]

May be like this

Regards

ASHFAQ

[#4]

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.