Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
got a pivot table with Dimensions TPK, Nickname
each TPK and Nickname has one Functional Contact
I want to display all Fucntional contact where Module = ' ' or null and functional contact is not null
I managed to write this:
Only
(
{
($-<MODULE={'*'}-{''}>)
*
<
IS_TPK_DESCRIPTION={1}
,TPK_QC_TEAM={'*'}
,RECORD_TYPE={'pushed job'}
,TPK_FUNCTIONAL_CONTACT={'*'}-{''}
>
}
TPK_FUNCTIONAL_CONTACT
)
and it is working just fine but now I want the result to be affected only by year and month of the master calendar
can someone help?
Perhaps this document helps: Ignore all selections except some specific fields using Set Analysis