Hi everyone, I have a dashboard view with a dynamic report with two views one is a table with data from a spreadsheet that shows in its columns 5 ways of payments, of 5 different services, this table cant be edited and is dynamic beceause the other view is a detail view that I use to filter values from different months.
It is already working because I have a SUMIFS formula in the SS, but it doesnt work as I want beacuse every time I change the value of the month it need to sync and then shows the value in the first table.
What I want is to build an expression that helps me to reduce the syncing time and works IN the table using the two tables and works dynamicly.
The SS formula in each cell is this:
SUMIFS(BD!C10:C10,BD!C7:C7,RC1,BD!C13:C13,R3C,BD!C15:C15,Mes!R3C1)
Iโve tried with this expression:
SUM(SELECT(BD[Amount],AND(BD[Service].[Service]=[Service],BD[Pmt method].[Pmt method]=โPmt methodโ(each),Mes[Mes])))
The expression says its valis but the result is 0, so I dont know what Im doing wrong.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |