Forum Discussion

imranamikhan's avatar
imranamikhan
Icon for Helper V rankHelper V
5 years ago

Ignore multiple filters in table

Hi everyone,   I have a fairly unique requirement I am trying to solve.   My data sources are 12 Excel tabs. Each Excel tab is numbered between 1-12. The numbers represent the month of the year ...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

imranamikhan Sorry, I am getting confused because you are using Period for the Excel sheet/tab and also as an additional attribute. When you say Period 1 should return Excel file 1 budget, what do you mean by that? It looks like Project A is in Sheet 1 with Period 1, Period 2, etc. Did you want a different budget for each of those periods? What dimensions should it keep?