filtering and adding back the value to another item in the filter
The filter is made up of product categories...
I have a filter which at visual or page level i can unselect a particular product that i do not want to show, but i want to then add back the value of the filtered item to another product category. so the overall total reamains the same.
i.e. remove from one product add to another....is this possible in BI
The problem is always uploading and or providing data.... i fully understand that post and agree that is the best method. See sample data. So what we have is Co's ABC and BCD so on...they all sell products as shown the companies and products are in Hierarchires in the source data. i want to dynamicall remove pear form ABC and add these values back to Pears in Co. ID..