on 02-10-2016 8:35 AM
Hi All,
Need your help with the below requirement in Webi 4.0
We have Gross Sales Value with a hierarchy of District Number and Store NUmber
when we put a section on Store Number to display the Gross Sales value, we need to show Gross Sales Value at the Store and also total at District Level
Store level works without any issue
but how to show district level total in section
Tried with below
=[Gross Sales Value] ForEach([District number])
the above only displays at specific store level
=[Gross Sales Value] ForEach([District number]) In Report
it displays total value in the report but won't split at district level
really appreciate any inputs on this..
it's a bit long description, thanks for your time and help
Can you try for this and let me know
[Gross Sales Value] ForEach([District number] In Section
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Saurabh,
Thanks for your quick reply.
I'm getting the store(section) level total with the context you have shared. Value is same with or without this context in the section.
I need to get the total at District level where as Section is on Store. Please see a bit detailed requirement as below.
If we have values like this
District Store Gross Sales Value
---------- --------- -------------------------
District 1 Store 1 100
District 1 Store 2 200
District 1 Store 3 300
Requirement to show as below.
Store 1 (Section)
Gross Sales Value Gross Sales Value at District Level
------------------------- -----------------------------------------------
100 600
Store 2 (Section)
Gross Sales Value Gross Sales Value at District Level
------------------------- -----------------------------------------------
200 600
Store 3 (Section)
Gross Sales Value Gross Sales Value at District Level
------------------------- -----------------------------------------------
300 600
Please let me know if you need any additional details.
Thanks again.
Amar
Hi,
Create new measure for gross value as v1 =sum([Grosssalevalue]) in([District])
Now take this measure in report and in section formula for v1 apply as [v1] forall [district]
I checked it worked see below .
If you don't want to show dist in report then you can use created variable directly and no need to use formula in section.
Thanks.
Hi Seshu,
Thanks for your detailed reply. I have tried creating a variable with Gross Sales Value at district level same as you have done. But it didn't help.
Please see the below. This is from Deski, which I could get the values in required format.
8001, 8308, 8370, 8400, 8443 are different Store Numbers on which section is there and all of the stores belong to same District Number 89.
Second column on Gross Sales Value is at Store Level and third column is at district level.
We need to get the same in Webi. Could you please check this and let me know.
Thanks a lot for your help.
Amar
Hi,
Can you share the formula that you have used in webi report.
Becoz may be you have wrongly defined with the sample data what you have provide base don that I created if it works for me it will definitely works for you .
One more thing after created variable used in report did you applied =[v1] forall (district )? as above screen shot. If you have not done do it.
Thanks
Hi Seshu,
sum([grossvalue] ) in( [district no]) giving me total value in Report. So I have removed Sum function for the variable definition.
I can't use ForAll for District Number as I need to get the sum at each district. Tried ForAll with Store Number. This gave total value in report again. Tried the combination of ForAll Stores with In/ForEach District. It didn't help.
Thanks
Amar
Hi,
If my understanding is correct, you have 2 levels of data and you have created a section at the second level and showing the aggregation at the 2nd level and also you want to show the aggregation of 1st level also at the second level.
Create a section 1st dimension, 2nd dimension
If you keep Sum([Measure]) at the second level then it will automatically gives the required aggregation,
Then create one more formula to get the 1st level aggregation as Sum([Sales revenue] )ForAll([Level1 Dimension])
In my example, i have create Section on State and Year.
Just sum[Measure] shows aggregation at year level , sum[measure] for all (Year) gives the state level aggregation. Which is same for each year in a particular State.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.