Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm having trouble writing a set analysis. I want to display the revenues generated by the people from a Business Unit (no matter if it is generated in another business unit) when said business unit is selected.
In other words :
if my current selection is BU = "A" , then I want sales generated by BU A Salesmen to appear, even if it was generated in BU B
Set analysis should be around : sum( { $ < BU= , BU_Employee= {BU} >}sales)
but I don't seem to be able to make it work.
Sorry, i can't post my data, it's in french and pretty much tangled with a lot of other info.
Thank you for your help,
Aurore
Hi,
Can you try this:
=sum({<BU=, BU_Employee={'$(=GetFieldSelections(BU))'}>}AmountSold)
Hi
Can you create a sample data atleast 5 to 6 and explain your scenario, it helps to understand the issue
If I understand correctly are you saying that Selected BU is A but in that Salesman for BU B also done business, something like that
Here is a sample :
BU | SalesMan | Amount sold |
A | John | 1 000 |
A | Steve | 10 |
A | Marc | 20 |
B | John | 100 |
B | Steve | 1500 |
B | Marc | 2000 |
John is from BU (business unit) A, Steve and Marc are from unit B. ==> This data figures in field "BU_Employee"
When I select BU "A", I want the amount sold 1100 (1000 in unit A + 100 in unit B) to be displayed.
Is that any clearer ?
----
Update : Here is the script for better understanding :
Sales:
Load * Inline [
BU,SalesMan,AmountSold
A,John,1000
A,Steve,10
A,Marc,20
B,John,100
B,Steve,1500
B,Marc,2000
];
Employee:
Load * Inline [
SalesMan,BU_Employee
John,A
Steve,B
Marc,B
];
Try this?
Sum({<BU=P({<BU>}) >}AmountSold)
But you have to select BU and SalesMan
Yes,
Also Salesman from A did business in A & B. I want sales done by Businessman from A when A is selected, regardless where sales were actually made.
Thanks but that won't do.
I need to not select SalesMan, as I need to present Sales per Business Unit in another graph.
Hi there,
have you tried aggregation?
Sum(aggr( sum(AmountSold), SalesMan))
Hope that helps
The expression will work if you have as dimension BU or SalesMan:
See the image below:
Sum({1<BU = P(Bu)>}Sales)
if dimensions are taken as BU and Salesman