Dear all experienced,
I am trying to make an app, Now I am suffering a problem,
It’s a sales app, I am doing it for 3 branches & every branch has 2 types of sales like Branch sales & online sales.
Now I am trying to generate a report between date on depends on sales type (like Branch & Online) and all means both sales also.
So I used below formula for the report & its working on branch & online, But I need more that will be for (sum of Branch & Online) & it will be shown when I click on (All) button,
How can I write the formula, Pleeease help me…
SUM(SELECT(Jaudat Jamuna[Burger],and([Date]>= [Start Date], [Date] <= [End Date],[Order From]=[Order Type])))
User | Count |
---|---|
41 | |
30 | |
29 | |
16 | |
14 |