BusinessObjects Board

Sum where q1.dimension = q2.dimension

building reports webintelligence
#1

I want to summarise the sales for the report month (last month), the sales come from another query with sales from other months as well.

The data looks like:

image
image937×1209 53.7 KB

I have merged the FUM ID and tried this formula to output a sum for March-21 in a single cell:

=Sum( [PO].[Sale Amount] ) Where( [repair month year] = [report month year] )

I’ve only been using webi for two months so any help or advice would be greatly appreciated! Thanks.

#2

Use context operators -ForEach,ForAll and In. For eg Sum(Sales in ) this must work.This would give you the total Sales for the respective Fum Id, ignoring the other dimensions in the block .