Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table like this
Year | Dept | Award |
2011 | Finance | 3 |
2011 | HR | 2 |
2011 | HR | 2 |
2011 | Sales | 2 |
2012 | Finance | 2 |
2012 | Finance | 2 |
2012 | HR | 2 |
2012 | Sales | 1 |
2012 | Sales | 2 |
2012 | Finance | 1 |
I am trying to setup dashboard for different department.
How do I display a table that shows only data for specific group, e.g. only Sales data using Set Analysis?
Year | Dept | Award |
2011 | Sales | 2 |
2012 | Sales | 1 |
2012 | Sales | 2 |
Check this
Use only({<Dept={"Sales"}>}Award) as expression OR
Use aggr(only({<Dept={"Sales"}>Dept),Dept) as dimension and check "Supress when value is null"
Hi,
Please find attached file for solution, created one new ID field in script and add it as the dimension field. Hidden this ID field in Straight table by using
Chart Properties -> Presentation -> Columns -> Select ID -> Select Hide Column
Hope this helps you.
Regards,
Jagan.
Hi Clever Anjos
Thanks for the prompt reply.
I cant seem to get it to work.
See the attached file
Thanks
Jagan,
I don't see the attachement
hi there,
use this expression sum({<Dept={'HR'}>}Award)
Regards
Prem
Check this
pfa.
Thanks. I understand now.
Thanks !