how to build inteligence into pivot grid

[Paavo Hänninen]

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

[Renuka N]

Hi Paavo, 

Query	Response
how to freeze rows/colums?	We had considered your request of “Freeze rows/columns in Pivot Grid” as feature.
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	Yes, it is possible with dashboard designer. You can create expression column with the following expression.  IF(ISNULL(Column Name)='true','EMPTY','NON EMPTY'). Please refer the UG link for adding expression column into dashboard platform.  http://help.syncfusion.com/dashboard-platform/dashboard-designer/transforming-data/configuring-expression-columns

Please let us know , if any queries. 

Regards, 

Renuka N