Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help in hiding the columns with values as Null or NA.
Example:
In the below data(Pic 1) i wan to hide the cells with values as NA. Basically i want to show the rep names for different rep types in one single row as shown in second pic(Pic 2). Please let me know if more clarification is required.
Pic 1:
I need result as below
Pic 2:
Message was edited by: Ayeesha Farheen
Check the attached
It seems that you are using Rep Type 1, 2, 3, 4, 5 as dimensions in your chart, but instead you might want to use it as expression... might have to share some data to see how it looks to give you the exact expression. Some modification might be needed for Sales and PY Sales expression also...
Hi Sunny,
Thanks for the quick response. Please find new working file attached. I have changed the numbers from above example. Kindly help me to get the solution.
Thanks,
Ayeesha
Check the attached
Hi Sunny,
You are really great. Got so quick solution for my problem. Thank you so much !!!!!!!!!!!!
one quick question. Is it possible to get the below view in the same table (above example). I want to show products as columns and their Sales and PY Sales below each product. Please let me know is it feasible.
It might be possible but what all dimensions do you need?
Same dimensions as in the above table (Acct no,Acc name, Division). Just need products as columns and their Sales and PY Sales below each product.
How about the Rep Type? They are needed as dimension also?
Yes..
Check the attached