lukasrubner
Contributor
2019-01-15
07:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pivot Table with conditional formatting for different KPIs that is unaffected by selections
Hell Everyone,
I am trying to create a table containing different formats (Whole numbers and percentages). This table also should not be affected by selections in a specific dimension (Sampletable attached).
I currently have a solution where my expression consists of an If statement like this:
IF(KPI = KPI1 OR KPI = KPI3 OR KPI = KPI4, num(expression,'#.'), num(expression, '#.##%'))
This does work as long as I do not select a KPI (needed in another part of the App). However, once I do select a KPI the formatting condition is ignored and all KPIs formatted according to the selection.
Is there a way to prevent that from happening?
448 Views
1 Solution
Accepted Solutions
rubenmarin
MVP
2019-01-15
10:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, try adding {1} to ignore selctions, also macth can be easier to manage than adding 'ors':
If(Match(Only({1} KPI), 'KPI1','KPI3','KPI4'), num(expression,'#.'), num(expression, '#.##%'))
Only() returns the same value, is only used to apply set analysis ({1}).
If(Match(Only({1} KPI), 'KPI1','KPI3','KPI4'), num(expression,'#.'), num(expression, '#.##%'))
Only() returns the same value, is only used to apply set analysis ({1}).
435 Views
1 Reply
rubenmarin
MVP
2019-01-15
10:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, try adding {1} to ignore selctions, also macth can be easier to manage than adding 'ors':
If(Match(Only({1} KPI), 'KPI1','KPI3','KPI4'), num(expression,'#.'), num(expression, '#.##%'))
Only() returns the same value, is only used to apply set analysis ({1}).
If(Match(Only({1} KPI), 'KPI1','KPI3','KPI4'), num(expression,'#.'), num(expression, '#.##%'))
Only() returns the same value, is only used to apply set analysis ({1}).
436 Views