Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a scenario where i want my pivot table to show count as shown in the pic.
Date:
ID | Name | Month | flag |
1 | q | Jan | 1 |
2 | a | Jan | 1 |
3 | z | Jan | 0 |
4 | x | Jan | 1 |
1 | q | Feb | 1 |
2 | a | Feb | 0 |
3 | z | Feb | 0 |
4 | x | Feb | 1 |
1 | q | Mar | 1 |
2 | a | Mar | 0 |
3 | z | Mar | 0 |
4 | x | Mar | 0 |
I am putting a green check image where ever flag=1 and i count i want to count number of flags for each month. I am pivoting the table on Month column.
Expression:
=if(Dimensionality()=0,Sum(flag), if(sum(flag)=1,'qmem://<bundled>/BuiltIn/check_g.png'))
Expression:
=if(Dimensionality()=0,Sum(flag), if(sum(flag)=1,'qmem://<bundled>/BuiltIn/check_g.png'))
Hi,
see Attachment.
Regards,
Antonio