Expressions within set analysis and use of expressions outside straight table

[Anji0610]

Hi All

I have two fields like below

Account, qty

A,100

B,200

,200

C, 500

Along with it I have a field whose value is input by user - Sales

I have an expression field - Sales*sum(Qty)/sum(total(qty))

If the value of expression is less than a threshold and the account field is blank , I would like to delete that row and calculate the expression again.

Let me know how this can be done using set analysis or any other method.

[chrismarlow]

Hi,

The following might work.

You can try an expression that you hide that returns 1/0 for show/hide row;

Then use dimension limits to only return 1's and not show Others;

Cheers,

Chris.

[Anji0610]

Hey,

Deletion of row will work. However, I am more confused about how to recalculate my expression