Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Right now I am trying to set up three pivot tables right next to eachother with the same dimensions of date and payment type so I would like to hide the dimensions on the 2nd and 3rd tables. Does anyone know how this is possible? The issue is that the column categories needed for it to be one pivot would be difficult to throw into the data model, so we wanted to go this route.
Another option is to just use a straight table since I can add in all of the measures but I would like to hide repeating dimension values. I have the paid Vizlib extensions available for use as well but did not see any options for either situation. For example, if we have checks and wires I want it look like this
5/19/2019 | PaymentType1 | ### | $$$ |
PaymentType2 | ### | $$$ | |
PaymentType3 | ### | $$$ | |
PaymentType4 | ### | $$$ |
and not this
5/19/2019 | PaymentType1 | ### | $$$ |
5/19/2019 | PaymentType2 | ### | $$$ |
5/19/2019 | PaymentType3 | ### | $$$ |
5/19/2019 | PaymentType4 | ### | $$$ |
EDIT: The pivot would be preferable because I need subtotals by date.
Go to the chart properts > Presentation section and flag the "Fully expanded" option.