cancel
Showing results for 
Search instead for 
Did you mean: 

How can I obtain a summary report from webi through counts and sum

Former Member
0 Kudos

I have a report built from webi. But will like to count the report by different categories.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Cobimah,

You have several options. You can simply add totals to the measure columns where you want a count or sum. Click on the column and then click the Sum button on the menu and you can count, sum, min, max, etc.

If you want a separate summary report, you can place formulas in the cells like =Sum([Measure Object]) or Count([Measure Object]), or create a variable as the same and place it in the cell.

You also have the option of creating the pre-aggregated objects in the Universe and then they are already there for you to use where you like if they are aggregations that you will be using often.

Thanks