Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I've created a straight table with a number of dimension and one expression. I now wan't to add a second expression (or dimension) which should be visible only when the furstexpression has a value in that column. If I add this dimension as a dimension or an expression, it is going to att rows to the table where the first expression has no value.
A little illustration.
Before:
Product | Category | Sum(sales) |
---|---|---|
shirt | clothes | 50 |
bag | accessories | 100 |
pants | clothes | 75 |
shorts | clothes | 30 |
jacket | outerwear | 80 |
After:
Product | Category | quantity | Sum(sales) |
---|---|---|---|
shirt | clothes | 5 | 50 |
bag | accessories | 1 | 100 |
pants | clothes | 5 | 75 |
shorts | clothes | 3 | 30 |
jacket | outerwear | 1 | 80 |
hat | accessories | 4 | |
shoes | shoes | 7 |
So Sum(Sales) is my first expression and quantity is my second. I don't want to show the rows where Sum(sales) is null. Is there an easy way to do this?
Hi ,
this can be done by writing an isnull operation for quantiry, if(isnull(sum(sales) = not null,quantity)
try this
Hi kimlindell,
You can use quantity expression as if(sum(sales) > 0 ,sum(quantity))
See the attached file
Regards