Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Table. and I want to restrict one dimension to a specific quarter.
QTR ABC DEF
==================
2019 Y Y
0 Z K
2018 K A
2019 M Z
I need to get the below output:
QTR ABC DEF
==================
2019 Y Y
2019 M Z
Hi, Peekay
Have you tried
=if(QTR='2019', QTR)
and then tick off Include Null Value as shown below?
Hope this helps
ZZ
Load
QTR ,
ABC,
DEF
From Abc.xlsx
where Left(QTR,4)=2019;