hi
i made pivot grid in order to see how customer orders per week developing. X-axis weeks and y-products.
two challenges:
- how to freeze rows/colums?
- how to build inteligence into grid reports. as example customerx/product y has not had orders in 3 or 4 weeks. Visually easy to see.
In excel you can play with =if(B2="", "EMPTY", "NOT EMPTY")- expressions. is it possible to do similar with dashboard designer