B
bchan
Hello gurus,
2 Questions -
Question #1:
Is there a way I can return a parameterized query/view from an externa
data to a pivot table? Whenever I create a parameter in MS Query an
return the data to Excel, the option for a pivot table is disable
forcing me to accept the entire data in a normal worksheet.
Question#2:
When creating a conditional IF calculated field in the pivot table,
can’t seem to make the pivot honor my formula. E.g. I create a formul
field based on the condition that “if the salesman = [001], return 10
else return 0” or * IF(Salesman=“001”,100,0)* . The column return
all 0 depending on the return value of the FALSE argument, indicatin
that the formula always returns FALSE. Has anybody seen this effect?
What should I do to create a conditional IF for a formula field
2 Questions -
Question #1:
Is there a way I can return a parameterized query/view from an externa
data to a pivot table? Whenever I create a parameter in MS Query an
return the data to Excel, the option for a pivot table is disable
forcing me to accept the entire data in a normal worksheet.
Question#2:
When creating a conditional IF calculated field in the pivot table,
can’t seem to make the pivot honor my formula. E.g. I create a formul
field based on the condition that “if the salesman = [001], return 10
else return 0” or * IF(Salesman=“001”,100,0)* . The column return
all 0 depending on the return value of the FALSE argument, indicatin
that the formula always returns FALSE. Has anybody seen this effect?
What should I do to create a conditional IF for a formula field