on 04-04-2016 10:34 PM
Hi,
did you apply condition on individual characteristics by choosing "comuna" and "referencia" ?
if you choose only one row in condition definition, then you tried to add another rows in the drill down at query analyzer level, you wont get correct results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jyothi
I have a question, can you help me?
What I can do?
most condition 0, is working well for me.
summary for a filter is not working, as I can do?
that option active.
actualmete I have the condition value> 0
in the load / tab I calculated result as: totalization
what else would I can do?
example
summary
brand value1
01 140
Note: In group does not take the condition> 0, must give 135.
how to make
Detailed
Brand Product value1
01 Prod1 -5
01 Prod2 140
--------------------------------
Total .................. 135
Nota: in detail if it meets the condition value> 0
thanks for your help
Hi Yimi,
if you want to see both summary or details value greater than 0 in same report on the fly, then you create two new conditions, and try below and see.
1) for detail, (only prodcut in rows)
value >0 apply condition on individula char : prodcut, brand
2) for summary, (when you remove product from rows )
value >0 apply condition on individula char : brand
check settings for calculate result as for the keyfigure in Bex query definition.
Hope this helps.
-Swati.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yimi,
if you use conditions and don´t tell the sysem any different, it´s doing the total always without considering the condition.
If you want to have something different, go to the properties of your key figure in query designer,
got to calculations
choose the totals calculation method that you want to use
regards
Cornelia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yimi,
check the settings for the key figure - maybe there is something wrong for the sigle values.
Or there is an exception aggergation set for the more detailed char that you are aggregating into the commune - sorry, but the screenies are so small, I can not really see what it is.
regards
Cornelia
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.