Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I made a pivot table, where I then created two columns with two different measurements: "Actual" and "To Do" (image below).
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.
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!
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!