Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with many fields. I have a lit box where I select a a campaign name to display in my pivot table. One of the fields of the pivot table has multiple values, let's say it's FiledX nad there are 5 possible values 1,2,3,4,5. When I select campaign name, my pivot table fills up, but lets say on this particular pivot table, I only want the data to display where FieldX = 5. I am having trouble doing this as an expression, FieldX = '5' and I am having issue setting it up with set analysis as well. And if I set this pivot table up to only display values where FieldX=5 and if none of the values in the pivot table relating to the chosen campaign name then the pivot table would contain no data. Can someone throw me a bone on this? Thanks much
Only ({<[Opportunity Stage] = {'100% - Closed Won'}>} [Opportunity Stage])
I only want data to display in the pivot table where this value '100% - Closed Won' exists. There are about 5 others that all relate to the campaign chosen in the list box but in the sheet object I only want to see the rows where '100% - Closed Won' is in the field Opportunity Stage.
Thanks,
I did not understand very well, it is obvious that if you just want to show FieldX = 5 and the campaign has no value 5, the table does not show data.
If your FieldX is a dimension you can do the following:
If (FieldX = 5, FieldX, Null ())
Regards.
With set analysis it should look something like
sum({<FieldX={5}>} Value)
Only ({<[Opportunity Stage] = {'100% - Closed Won'}>} [Opportunity Stage])
I only want data to display in the pivot table where this value '100% - Closed Won' exists. There are about 5 others that all relate to the campaign chosen in the list box but in the sheet object I only want to see the rows where '100% - Closed Won' is in the field Opportunity Stage.
Thanks,
You need sum your data?
In this case use:
Sum({<[Opportunity Stage] = {'100% - Closed Won'}>} [Opportunity Stage])
Regards.-
Sean, your expression looks fine. Can you post a reduced version of the QVW?
Try something like this
Only ({<[Opportunity Stage]={'100%*Closed*Won'}>} [Opportunity Stage])