Hello there Excel people,
After a lot of searching, i've finally found a formula that allows me to put texts on the value field. I had to use DAX for it (of course) and it actually works but there's a catch. I need the pivot table to show not only the rows with information but also the ones that don't have any. Let me show you:
1excel.png
That's my data base.
2excel.png
This is what i get using the DAX formula.
3excel.png
Yet this is how i want it to be displayed.
And this is the formula that i've been using so far: =IF(COUNTROWS(VALUES(Table1[first_name])) > 1; BLANK(); VALUES(Table1[first_name]))
Is there anything that can be added to show exactly what i want? Thanks.
Bookmarks