on 2023 Feb 23 8:13 AM
Hello everyone,
I would like to ask how to do with some function in WEBI report like SQL having clause? I have a dataset I like to calculate first measure (an average of sold items in sales manager dimension) and second measure (total costs per sold items on row level). But if I filter second measure the first one is recalculated. I tried to use NoFilter function, but I like to keep one dimension report filter. For this one dimension it is all right, that the measures are recalculated.
Thanks in advance
Best Regards
Ondrej
Request clarification before answering.
Hello everyone,
would have someone another advice?
Thank you in advance,
Ondrej
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi this should work:
[first measure] = average ( [sold items]) where (category = "cizokrajné") In ([sales manager])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
30 | |
8 | |
7 | |
6 | |
6 | |
6 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.