Barchart Total

[Anonymous]

I face the following Problem: I have products with plan and actual. not all products have plandata.

In  straight table I define for actual (if plandata>0, sum(actual)) and I define "sum of rows" and it's good (no totals)

In a barchart I need the totals but only for those products which had been defined a plandata.

But when I define totals, there is a total for all  products. Even if I Change my Dimension If (product <>'C',Product,null()) it doesnot work

How can I achieve that I see the total Actual only for those products which had been planned In the attached sample, the total should Show 150 for Actual but not 350!

any idea?

[sunny_talwar · Accepted solution]

This may be?

=if (column(1)>0,sum({<Plan = {"=Len(Trim(Plan)) > 0"}>}Act),null())

[MK_QSL]

Like this?