Is there a way to count blanks in a pivot and display the answer in a text box.
In my screenshot below, how do I count the blanks (those circled in blue) ?
My formula for the expression is as follows
if(Sum(Sales) <=0, chr(10007),' ')
for foreign_exchange measure for example, in textbox;
(supposing that your foreign_exchange expression is sum(foreign_exchange)
Thank you for your reply. I've tried that , but does not work. The screenshot that i have given is a pivot table and there is only one formula. The headings that you see are values of a horizontal dimension in a pivot.
so try this:
Thank you Youssef. Will try and let you know.
Retrieving data ...