hi Folks
I want to create two measures for a pivot table.
In columns
I got month/year (pulled in from a related calendar table)
Then I have account headings e.g. Revenue, Expenses
In Row labels I have a list of project IDs
In my values I have created following measures:
Month_only - this to show the transactions for that month only, for that account heading only, for that specific project.
The measure called [Total_accounted_field] I am using for this is:
=SUM('transaction_table'[accounted_field])
Then for the cumulative I am using the following:
(I want this field to show the total in this category to date the projects could stretch over a number of years which is why I'm not using the TotalYTD)
calculate([Total_accounted_field],all(Calendar[Date]))
Unfortunately this is giving me exactly the same as [Total_accounted_field]. I had thought that using ALL would clear all dates - just giving me a total..
Thanks as always...
I want to create two measures for a pivot table.
In columns
I got month/year (pulled in from a related calendar table)
Then I have account headings e.g. Revenue, Expenses
In Row labels I have a list of project IDs
In my values I have created following measures:
Month_only - this to show the transactions for that month only, for that account heading only, for that specific project.
The measure called [Total_accounted_field] I am using for this is:
=SUM('transaction_table'[accounted_field])
Then for the cumulative I am using the following:
(I want this field to show the total in this category to date the projects could stretch over a number of years which is why I'm not using the TotalYTD)
calculate([Total_accounted_field],all(Calendar[Date]))
Unfortunately this is giving me exactly the same as [Total_accounted_field]. I had thought that using ALL would clear all dates - just giving me a total..
Thanks as always...