Skip to Content
0
Nov 26, 2018 at 08:36 PM

Count rows with same value for a field

67 Views

Hello Gurus,

Simple question for you all. I've the below table, Total is a calculated field, and my requirement is to show the it as 2, wherever we have the Desc as Analyst. I want to do that without creating Groups. What's the way to do it? Obviously, if there are 10 rows with Desc as Analyst, the Total column would show 10. In Webi, I would use Context operators and do it easily. Please help.

ri01.png

Thanks,
Mahboob Mohammed

Attachments

ri01.png (4.8 kB)