Row total Label

HI,

But my requirement is not row total as per the Pivot table, i am looking for a row total where i have one dimension and one measure as Column (not as you mentioned in your screenshot).

I am looking for the row total as per the screenshot mentioned in my request.

Thanks,

Venu

Hi Venu,

Is your request to have the total value from the measure displayed under the dimension value, like so?:

If so, this is not possible. The only row total option here is to provide a count of values in the corresponding column:

Please clarify if this is what you're looking for and if it is, why this would be a desirable way to display your data, specifically vs. a Totals column, as this seems to be an unusual way to display report data.

Thanks,

Mike

Hi Mike,

Thank you for providing step by step process. But i want to display only a label like 'Total' at the place of 4(as per the screenshot provided by you).

Thanks,

Venu

Hi Venu,

Thanks for your reply. As stated in my previous responses, this is not possible to achieve... in other more detailed words, it is not possible to display the Column Total of <Column2> as the Column Total of <Column1>, and I cannot think of a reason this would be an easily read or desirable functionality. Please let me know if you have any further questions.

Regards,

Mike

Thanks for your reply Mike.

My question very strait forward, when i created this ticket, i have attached a screenshot where i am looking for Label when i do some row total or average, i want to label it like Product Total or Item Total.

Now i understood, this functionality is not supported by Yellowfin. We can't put any label like Total or Product Total or something else.

Hi Venu,

That is correct. This functionality is not supported by Yellowfin and will not be, as this certainly constitutes an edge case. One potential option would be to add a row at the data level in your Account column in your db that is the sum of the values of another column. Sorry there's not a simpler solution. Please let me know if we're okay to close this case.

Thanks,

Mike

Hi Venu,

In order to accomplish what you want, you will need either a union or go with the row totals that Mike demonstrated. That is a cleaner option but a union (sub query) will give you the formatting that you are requesting. If you choose to go the subquery route, you will need the same exact filters and then link to the master query. Create a calculated field with the value 'Total' and summarize the data. In order to sort, you can create a reference code, choose custom sort and set everything to 0 which will then default to alpha and then create a code 'Total' with the value of 1. That will place 'Total' last. Another trick I used to use are fake heading tags. Choose HTML format for the column and make the account '<h100>'+account+'</h100>' and then set total as '<h101>Total</h101>'. The reference code is better in the long run. Hope this helps.

And you want to highlight the row you can create a conditional format for when account = Total. You will have to do that for every column.

Hi Larry,

Thanks for your input. These are some interesting outside the box suggestions here!

Venu,

Hopefully you find one of our suggestions helpful.

Regards,

Mike

Thanks for your quick response. The suggestions really good workaround solutions.

You can close this request.

Thanks,

Venu

Hi Venu,

You're welcome. Happy to help. Thanks again Larry. I'll go ahead and mark this as Answered.

Please don't hesitate to reach out with other questions or concerns.

Regards,

Mike