Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I dont know if i am able to do this.
I have a Funnel chart where i have a count of companies from my listbox Milestone.
Can i include a value in my expression so i would get values from my listbox phases
I am thinking something like this?
=Count({$<DimSalesPhases.Milestone=e({$<DimSalesPhases.Milestone={'UKENDT'}>} DimSalesPhases.Milestone),
DimPotentialCustomers.RelationID=p({$<DimPotentialCustomers.RelationID={'11'}>} DimPotentialCustomers.RelationID) DimPotentialCustomers.Company)
So first im excluding a value from milestone (that works fine if i only have this) But next i want to include a valaue from another listbox - but i cant seem to figure out the expression?
try this
Count({$<DimSalesPhases.Milestone=E({1<DimSalesPhases.Milestone={'UKENDT'}>}),
DimPotentialCustomers.RelationID=P({1<DimPotentialCustomers.RelationID={'11'}>})>}distinct DimPotentialCustomers.Company)
count({$<DimSalesPhases.Milestone=E({<DimSalesPhases.Milestone={"UKENDT"}>}),
DimPotentialCustomers.RelationID=P({<DimPotentialCustomers.RelationID={"11"}>})>}distinct DimPotentialCustomers.Company)
Try:
=Count({$<[DimSalesPhases.Milestone]-={'UKENDT'},[DimPotentialCustomers.RelationID]={11}>} DimPotentialCustomers.Company)
This will exclude companies with milestone value UKENDT and include only customers with relationid 11.
...or are you looking for this perhaps:
=Count({$<[DimSalesPhases.Milestone]-={'UKENDT'}>+<[DimPotentialCustomers.RelationID]={11}>} DimPotentialCustomers.Company)
That does not work - It marks read for ukendt to the last line.
However i dont think i was specific enough.
My Milestone consits of:
UKENDT
A
B
C
D
I want to exclude companies with milestone value UKENDT, but show all companies from A,B,C,D - and then i want to show all companies from value K in RelationID
Yea something like the plus i think.. if that is adding the value to the others even though its from another list
I can show what i get.
The first picture i have all my values but excluded UKENDT on DimSalesPhases.Milestone
Next i have ALL values from DimPotentialCustomers.RelationText - BUT what i want is, that i want to show only CLOSED (but together with my DimSalesPhases.Milestone)
IS that even possible??