mdoria
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Need to filter rows based on value from one column
Hi Ravid_PaldiTeam , this functionallity can be used only as developer, the viewer should be able to filter pivot tables based on formulas calulated inside the pivot. Example, I want to show unit cost per product in a flexible time period. You will need a pivot table with [unit cost] = total cost/nº units. The viewer should be able to filter the pivot table based on the column [unit cost], or having a filter on the dashboard that can calculate [unit cost] = total cost/nº units and filter based on it. Currently you only can filter by data that is already on the cube, not data that is being aggregated on the dashboard.4.8KViews1like0Comments