1

I have a report with OrderIDs and related boolean dimensions for each order. I want to create a calculated dimension counting the boolean results for each dimension/object. Is this even possible in Webi or do I need to modify the universe?

I have a table with OrderID in rows and three columns that each give 0 or 1:

Table with rows per OrderID

and I want to calculate it so that the columns give three rows and the columns count the number of OrderIDs with 0 and 1 for each:

Aggregated table

Because the end users want it to look like this in the report:

Diagram

Any suggestions how to do this?

I've tried running count but it doesn't work.

Improve this question
Related questions
0
Countifs across BO Webi merge like correlated subquery
0
Perform sum of values then getting rid of decimals SAP WEBI report
0
Calculate weekly average of column in Webi
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.