Below in the pivot table displaying units for staffs based on their allowances.(pivoted by dimension pay element)
I have added drill fields for the measure unit,to display details for the staffs when they click on the unit value.
However for certain pay elements such as for example for Incentive $1 or weekly elements, when they click on the unit,I require to hide certain columns such as the clock -in ,clock outs fields.
How do I achieve this?
- measure: unit
drill_fields: [view_staff.username, view_staff.name, from_date, to_date, pay_element, unit,view_attendance_review.paid_work_duration,view_attendance_review.paid_clock_in_time_of_day,view_attendance_review.paid_clock_out_time_of_day, view_attendance_review.paid_break_duration_in_h,view_previous_roster.final_remarks]
On clicking the units below is the drill view ,how do I hide columns within the drill view for selected pay elements that is pivoted.
Let me know if there is an solution for this ,