Skip to Content
0
Former Member
Jan 16, 2017 at 08:32 AM

RE : How to Calculate Row and Coloumn Count from different blocks in webi

68 Views

Hi,

We have created a report in webi Rich client, As per requirement we have different unit of measures and created report with different blocks and applied conditional formatting with colors (R/G/Y) by applying Threshold values. Now the requirement is to Calculate Row and Column count and display them as Percentages how many Reds/ greens/Yellows in both Row and Column of the report. For example : Row Count it should count how many R/G/Y from different blocks( As we have different unit of measures and created report with different blocks) and display them as percentages. How to calculate the count of colors (R/G/Y) in different blocks and in a single table with all the blocks included in it? Please find the below sample screen shot.

Attachments

vqqie.png (14.3 kB)