I have data for
Date
Expenses
Amount
Total
But the total shows every row
May I know what need to key in row filter condition to make Total shown once and monthly, thank you !
Are those 4 tables, or 4 columns, or what? Show your data.
"the total shows every row", what exactly does that mean?
How are you expecting a row filter condition (in a slice?) to get you what you want here?
โ
Schaue zuerst diese Video, wie der Ausdruck "SUM" angewendet wird: So summieren Sie Werte in Ihrer Tabelle .
Dein Slice-Ausdruck fรผr eine monatliche Summenausgabe wรคre:
SUM(SELECT(Tabelle[Kosten],MONTH([Datum])=MONTH(TODAY()))
But it shows every row, can it just show once?
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |