Forum Discussion
Fields when drilling down into a PivotTable
Hi I've created a PivotTable from a PowerBI dataset as per the below image. Not every available field has been selected but when it comes to double clicking on one of the numbers only cert...
Hi, RossBateman96
What kind of output do you expect based on the data you provided? Can you provide an example?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
The current output when a value is drilled into is as follows:
-Company
-Entry_No
-Document_Type
-Document_No
-Purchase_Order_No
-Kg
-G_L_Account_Name
-FIeld
-Department
-Amount
(and a few more)
Not all of these are included in the pivot and some of the fields included in the data set table arent showing at all, such as Posting_Date & PAYROLL. I'd ike the output to include all of the fields from the orginal table (shown in the screenshot below).
Thanks,
Ross