Can we get sub total labels according to the dimension values

[kkkumar82]

All,

Find below images

Can we achieve the second image.

Ignore the green rectangles , can we get the subtotals labels in the above way, in general we get a unique labels for eg total for all product values.

Thanks

Kiran Kumar

[asgardd2]

You can configure your label for Totals  in Presentation tab (object settings)

Like this:

=[Product ID] & 'total'

[Peter_Cammaert]

The search box is your friend here. Spares you the time it takes to post a long question.

I found the following using a simple search: Showing Dynamic "Total Label"

[MayilVahanan]

HI

Only we can achieve like below link

https://community.qlik.com/message/251980#251980

And vote for this idea

[kavita25]

Try this expression

If(Dimensionality() =1, ProductID& ' Total : ' & Sum(Sales),Sum(Sales))

and tick the check box of Show Partial sums for SalesmanID and give Space for "Labels For Totals".

[kkkumar82]

Thanks all,

But none of all options are working. I am attaching a sample.

Thanks

Kiran Kumar

[kavita25]

PFA

[kkkumar82]

Thanks Kavitha for taking time but  this way doesn't work for me as I have 4 dimension and two of them are pivoted.

Any other work arounds you suggest.

Thanks

Kiran Kumar

[kavita25]

Okay..send the sample qvw as per ur requirement.

[kkkumar82]

The requirement is just like the second pic in my original post above .Don't mind its customers data I cannot upload any file.

Thanks

Kiran Kumar