Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a listbox to use as a filter for a pivot table that I have, the problem is that the displayed columns in that pivot table are all created by expressions, is there a way I can have the listbox show these choices?
thanks for the help, I ended up just using an in line load to fix the issue.
if you want to filter the expression result in your pivot table, try:
aggr(YOURPIVOTABLE_EXPRESSION,YOURPIVOTABLE_DIMENSION_1, ... YOURPIVOTABLE_DIMENSION_N)
A sample would help...
well, right now I have a table with 3 different calculated columns, so 3 different expressions. the pivot table is using 3 dimensions, expense_type, Line_type, Line_subtype. each of the 3 expressions are almost identical. here is one of them for an example:
(sum({< SOURCE_TYPE = {'ACTUAL'},MONTH = {"$(=MONTHSTART(today()-1,-1))"},EXPENSE_TYPE-={'Base Headcount','Contractors','HR Physical Headcount'} >}AMOUNT)
/
sum({< SOURCE_TYPE = {'PLAN'},MONTH = {"$(=MONTHSTART(today()-1,-1))"},EXPENSE_TYPE-={'Base Headcount','Contractors','HR Physical Headcount'} >}AMOUNT))
-1
any help is appreciated
try
aggr(
(sum({< SOURCE_TYPE = {'ACTUAL'},MONTH = {"$(=MONTHSTART(today()-1,-1))"},EXPENSE_TYPE-={'Base Headcount','Contractors','HR Physical Headcount'} >}AMOUNT)
/
sum({< SOURCE_TYPE = {'PLAN'},MONTH = {"$(=MONTHSTART(today()-1,-1))"},EXPENSE_TYPE-={'Base Headcount','Contractors','HR Physical Headcount'} >}AMOUNT))
-1
,
expense_type, Line_type, Line_subtype
)
as Listbox expression:
thanks for the help, I ended up just using an in line load to fix the issue.