Forum Discussion
What is the best way to replace a table that is referenced by multiple formulas ?
Hello, I have a dashboard with multiple formulas and a couple of pivot tables that reference a table on a worksheet in the same workbook. I need to replace the entire table weekly because the data ...
Hello,
Thank you for the quick reply. I have a follow up question. For now, I have a few formulas that I'm not using the Pivot Table for. Should I reference the pivot table or use the column title ?
Current formula: COUNTIFS(DATA!AE2:AE513,"<="&TODAY()+30,DATA!D2:513,"MCA")
Will one of these work:
COUNTIFS(DATA!COLUMNTITLE,"<="&TODAY()+30,DATA!COLUMNTITLE,"MCA")
COUNTIFS(PIVOTTABLENAME!PIVOTFIELD,"="&TODAY()+30,PIVOTTABLENAME!PIVOTFIELD,"MCA")
Is the GETPIVOTDATA used here instead?
Thank you for your help.
C
Thank you for the quick reply. I have a follow up question. For now, I have a few formulas that I'm not using the Pivot Table for. Should I reference the pivot table or use the column title ?
Current formula: COUNTIFS(DATA!AE2:AE513,"<="&TODAY()+30,DATA!D2:513,"MCA")
Will one of these work:
COUNTIFS(DATA!COLUMNTITLE,"<="&TODAY()+30,DATA!COLUMNTITLE,"MCA")
COUNTIFS(PIVOTTABLENAME!PIVOTFIELD,"="&TODAY()+30,PIVOTTABLENAME!PIVOTFIELD,"MCA")
Is the GETPIVOTDATA used here instead?
Thank you for your help.
C
IMHO, first one could work if modify as
=COUNTIFS(tbl4pivot[COLUMNNAME],"<="&TODAY()+30,tbl4pivot[ANOTHERCOLUMNNAME],"MCA")
If take data from PivotTable that's cube formulas assuming you added data to data model creating PivotTable.