I have a pivot chart with County, City , Year and Sales. ( Year is on the top X- Axis ).
Our users want to change the value for certain Project_id( this is the detail level). They just want to make the sales 0 ( zero) for them.
So i thought we cound provide them with a button, which can do the Partial Reload and then only for the selected Project ids we can multiply the value of the sales by -1.
Sales_F:
Add Only
Load
Country,
City,
Sales
resident Sales_F
where
Projects =$(var_Project_id);
So since this has ADD ONLY, this would work only on the Partial Reload. But the issue is i use a function GetCurrentSelections for the variable ( $(var_Project_id)). I get a error message on Partial Reload tht GetCurrentSelections cannot be used.
