two different measures with different filter values applied within the same table

[francesctesi]

hi,

I made a pivot table, where I then created two columns with two different measurements: "Actual" and "To Do" (image below).

Pivot table original

To obtain the desired values, I apply a filter on the 'Document' dimension where I select only a few possible values, thus obtaining the correct values in the first 'Actual' column.

I would like to make sure that the second 'To do' column also gives me the correct measurement, but calculated on different values of the 'Document' dimension.
Is this possible? Because obviously if I select certain values on the filter this affects all the data.

[RafaelBarrios · Accepted solution]

Hi @francesctesi 

I'm not completely clear about what you need, but it seems to me that what you want is for the TODO formula to ignore your "Document" selections and consider others.
if that's the case, you can try:

Sum({< Document >} amount_field)

this will ignore any selection on  Document  dimension

Sum({< Document={"P*"} >} amount_field)

this will ignore any selection on  Document  dimension and will consider every Document  that start with "P"

Sum({< Document={"P*"},date_field={">=$(=date(yearend(today())+1)"}  >} amount_field)

this will ignore any selection on  Document  dimension and will consider every document that start with "P", also will ignore any date_field selection and consider next year documents

Sum({1} amount_field)

this will ignore everything

hope it helps

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!