1. Right-click the PivotTable and select PivotTable Options. 2. Check Show items with no data on rows and Show items with no data on columns. 3. Click OK. If you are connected to Kepion, you should see the table with full axis information according to your PivotTable selections. If your PivotTable is not connected to Kepion, you must. 2 days ago · Show values in a pivot table using VLOOKUP. The first one uses a helper column with the VLOOKUP function.. Create a new column, called Helper between the Model and Licence columns.; Merge Id, Name, Brand, Model,. Enter dynamic SQL. Typically frowned upon, this is one of the scenarios where you are likely to make a strong case for its use. We can simply build the output / pivot column list at runtime, and append it to the rest of the query: DECLARE @columns NVARCHAR(MAX), @sql NVARCHAR(MAX); SET @columns = N''; SELECT @columns += N', p.' + QUOTENAME(Name. Jul 10, 2013 · You will find that option in option section of power pivot , right click and see. It will show rows/columns even for empty data also. very good technique to build dashboard in pivot itself. Friday, February 14, 2014 6:00 AM. First, import your dataset into your Power Pivot workbook. Next, in the Power Pivot window on the Power Pivot Home tab, click PivotTable. Next, select "New Worksheet" (Excel will add an empty PivotTable). Then, select the empty PivotTable and follow the instructions detailed there.