Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to make only few values of a dimension as bold and else values as normal in a pivot table. But the condition in the expression is getting affected only if the dimension is having value in measure. Else in is not getting effected.
For example:
The dimension values are Pens, Pencils and Erasers. And measures is Count of those items sold by month.Now i am displaying in the below format:
| Count of Items sold
____|__________________________
Item | Jan 2018 Feb 2018 Mar 2018
---------------------------------------------------
Now for Pencils i dont have any values for Jan 2018 due to which Erasers is not becoming bold even if it has values in Feb and Mar.
Can anyone help me please? Thanks in advance!!
Regards
Santhosh Kasam
santhosh kasam wrote:
Now for Pencils i dont have any values for Jan 2018 due to which Erasers is not becoming bold even if it has values in Feb and Mar.
Can you explain little more for highlighted one?
Hi Santosh,
please can you attach a sample .qvw or a printscreen so we can better undestand and help you?
S.
untick supress zero-values in Presentation tab and check it