Forum Discussion
Solved
Tricky? Excel365 problem
I have a problem that is causing me some distress... I have a table (Email Address, Domain, Product, Assigned by <person>?). The first 3 columns are extracts from existing data. The fourth column is...
Perhaps you may use this approach SUMIF Visible Cells - Excel Tips - MrExcel Publishing
Hello,
There are some cube formullas to get values from a pivot table, However if you are using Table slicers there is no way to get the slicer value or assign cell for binding its value.
There are some cube formullas to get values from a pivot table, However if you are using Table slicers there is no way to get the slicer value or assign cell for binding its value.
- Right...never understood the why's and wherefore's behind that one, but I'm trying to use something to workaround (wondering about using OFFSET to get the values)...
If I understood correctly first 3 columns of the table are returned by Power Query and 4th one is added manually. If so they are not in sync, as soon as you refresh/update Power Query Y/N will be against another rows.
Assuming email addresses could be used as unique ID you may sync columns loading first 3 columns, add 4th ones, query resulting table again and merge with initial one. All shall be done within one query. With table for slicers could be done by one more query.
If above assumption is wrong desirably to have bit more details, better the sample file.
- Hi Sergei,
Thanks for the response.
Sync isn't an issue, the query is only run for the initial setup. Running an additional query would eliminate the dynamic results for the user...Unfortunately, I can't give a full sample file, but the .png should provide the scenario...
Then the user places a "Y" in the assigned column, it should dynamically update the count for the product. If I could find the first visible row in the table, I could use offset with the visible row reference to generate either a subtotal or aggregate function set of values on the visible rows and combine it with sumproduct to create what I want, but getting the first visible row is a real sticking point....
