Hi,
I have created a pivot table that is built up of a number of tables in a data model. The N numbers are from a look up called WBS LookUp. The numbers beginning with 43000 are purchase orders from a PO LookUp. The PO's Raised, Invoices Paid and To be Delivered columns are all from different tables which are seperate spend reports and are linked by the look up tables. The Invoices Paid + To be Delivered is a custom measure.
I am trying to create a new measure that will show the status of a PO, whether it is closed or open based on if the value in To be Delivered is £0 or not, which works. However, when I add the measure to the pivot table it ignores the filtering / sorting created by pivot table rows (the WBS Look and PO Number) and creates a new row for every PO number in each field row and can be seen with the £0 values.
I have tried using calculate to filter by various tables and fields to solve the issue but I can't seem to resolve it.
Thanks in advance for any assistance.
I have created a pivot table that is built up of a number of tables in a data model. The N numbers are from a look up called WBS LookUp. The numbers beginning with 43000 are purchase orders from a PO LookUp. The PO's Raised, Invoices Paid and To be Delivered columns are all from different tables which are seperate spend reports and are linked by the look up tables. The Invoices Paid + To be Delivered is a custom measure.
I am trying to create a new measure that will show the status of a PO, whether it is closed or open based on if the value in To be Delivered is £0 or not, which works. However, when I add the measure to the pivot table it ignores the filtering / sorting created by pivot table rows (the WBS Look and PO Number) and creates a new row for every PO number in each field row and can be seen with the £0 values.
I have tried using calculate to filter by various tables and fields to solve the issue but I can't seem to resolve it.
Thanks in advance for any assistance.