Forum Discussion
Solved
using data in power pivot
hello, i am very new to power pivot and eager to learn abilities. i have a data like the one below. what i want to do is to find the sum of total sales of the customers who have sales via web. fo...
Sorry, busy on this week and thank you for the clarification.
To receive result like this
we may use two measures
Sales:=VAR SW = SUMX ( Range, Range[sales via web] ) VAR SE = SUMX ( Range, Range[sales via employee] ) RETURN IF ( ISBLANK ( SW ), BLANK (), SW + SE ) and Total Sales:=SUMX ( GROUPBY ( Range, Range[customer] ), [Sales] )Please check in attached file.
I think, I havent expressed what i needed clearly.
In the sample data, customers 10004427, 10004462 and 10004537 have sales via web. customers 10004416 and 10004419 dont have sales via web. what i want to find is the total sales (sales via web + sales via employee) for customers 10004427, 10004462, 10004537, regardless of date. so in my sample data, for customer 10004427 total sales is 0.12+0.1 = 0.22, for customer 10004462 total sales is 0.22+0.22+0.22+0.24+0.1+0.24=1.24 and for customer 10004537 total sales is 0.66+0.76+1.18+1.08+1.14+0,02+0.76+0.98=6.58. for this sample data the grand total i want to see is 0.22+1.24+6.58=8.04. this can either be a new column or a measure, this is not important. maybe this is something that cant be done with power pivot.
thank you very much for your time and your help.
In the sample data, customers 10004427, 10004462 and 10004537 have sales via web. customers 10004416 and 10004419 dont have sales via web. what i want to find is the total sales (sales via web + sales via employee) for customers 10004427, 10004462, 10004537, regardless of date. so in my sample data, for customer 10004427 total sales is 0.12+0.1 = 0.22, for customer 10004462 total sales is 0.22+0.22+0.22+0.24+0.1+0.24=1.24 and for customer 10004537 total sales is 0.66+0.76+1.18+1.08+1.14+0,02+0.76+0.98=6.58. for this sample data the grand total i want to see is 0.22+1.24+6.58=8.04. this can either be a new column or a measure, this is not important. maybe this is something that cant be done with power pivot.
thank you very much for your time and your help.
Sorry, busy on this week and thank you for the clarification.
To receive result like this
we may use two measures
Sales:=VAR SW =
SUMX ( Range, Range[sales via web] )
VAR SE =
SUMX ( Range, Range[sales via employee] )
RETURN
IF ( ISBLANK ( SW ), BLANK (), SW + SE )
and
Total Sales:=SUMX (
GROUPBY (
Range,
Range[customer]
),
[Sales]
)
Please check in attached file.
mehmetalidumlu , you are welcome