follow the example below - select format - alignment and when the box opens go to header and select Left
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
This works out only if the hierarchy is set in the data but unfortunately that is not the case. The headers in the data are basically KPI fields that club together to quantify a certain subject area. Please find below one such example:
Efficiency Hard work Indicator 1 Indicator 2 Indicator 1 Indicator 2