Forum Discussion
How to show transactions between two dates that differ for each row
Hi
This should be so easy. Im unsure why you are having a problem doing this
Just set up a column chart with dimension = staffname and sum (Amount)
and a matrix / or table with the required dimensions and sum(Amount)
click on the bar chart as required to drill down
edit But you realy need to be a lot clearer as to what you want or what your problem is. Im still not sure
Thank you both for your help. To clarify in a little more detail, I have managed to get the following data using the calculate formula I attached above that shows the sum amount of transactions that falls between the start and end date, but what I would like to do is show the individual transactions that make up the sum amount.
I currently have :
| employee name | Start date | end Date | Total of transactions |
| John doe | 01/02/2014 | 23/04/2015 | £15,560 |
What I would also like to show as well is the transactions that make up that amount
| Transaction amount | Transaction date | Description | Reference |
| 1000 | 14/02/2014 | Purchase | 1231 |
| 14000 | 16/07/2014 | card payment | 4123 |
| 560 | 16/07/2014 | Cash | 1231 |
Ideally on a powerBI desktop page, what I would want is a bar chart showing the spend by individual(from the data in the top table) that I could click on that would then filter a transactions table underneath to show what transactions make up that total amount.
It may not be possible, but at the moment I'm having to manually filter for the dates for the relevant employee to show the transactions that make up the total sum of transactions for that period and I'd like to be able to do it automatically
RJResolver II
Hi
This should be so easy. Im unsure why you are having a problem doing this
Just set up a column chart with dimension = staffname and sum (Amount)
and a matrix / or table with the required dimensions and sum(Amount)
click on the bar chart as required to drill down
edit But you realy need to be a lot clearer as to what you want or what your problem is. Im still not sure