I need to create something like this in SSRS:
My source dataset is fetchxml. I have actually two datasets.
One dataset is just the datapoint "347" whereas the other datapoint is "1000"
Dataset_Active returns 347
Dataset_InActive returns 1000
I have the option of using these fields for the following 3 categories:
My issue is that I cannot use values from multiple datasets.
How do I create a pie chart where the data comes from 2 different datasets? Also in the case that I just neeed to graph 2 values, should I use anything in the category/values/series or just use values?