I am trying to make a Trellis chart to display a measure across a dimension.
I have a dimension (let's call it "components") which consists of these text values:
Folkemengde, Fødte, Døde.....
I have a measure (we can call it "components_measure" constructed like this:
Pick(Match(Valg_demogr_komponenter,'Folkemengde','Fødte','Døde','Eksterne innflyttere','Eksterne utflyttere','Eksterne nettoflyttere','Interne innflyttere','Interne utflyttere','Interne nettoflyttere',)+1,
'-',
Sum(Folkemengde_3112),
Sum(Fødte),
Sum(Døde),
Sum(Ekstern_innflytting),
Sum(Ekstern_utflytting),
Sum(Ekstern_innflytting)-Sum(Ekstern_utflytting),
Sum(Intern_innflytting),
Sum(Intern_utflytting),
Sum(Intern_nettoflytting)
)
When I make a table of "components" as dimension and "components_measure" as measure everything is fine.
I have made a master visualization with "components" as dimension and "components_measure" as measure. This line chart dispays a line for each component.
Then I try to make a Trellis chart with "components" as dimension and "components_measure" as measure.
The result is a chart for each dimension value but all charts are replicas of the master chart content :-(.
