Error column subtotals on visual table

[chrisyan_manalu]

Hi everyone,

Actually I'm facing problem with this the column subtotals of the table below (Red Highlight)

The output should be like this :

• Category = 351
• Inhouse = 39
• Public = 45
• Sharing Session = 5 (true)
• Webinar = 224 (true)

And I'm just set Column subtotals and Row subtotals to Active

Why total value from Jan to Aug from all Category it did not match ? 

What I'm doing just drag and drop the axis and the value to table 

Is it bug ? 

Please help.

[chrisyan_manalu]

Hi @Adescrit 

Are there any other filters on the page or visual that could be impacting the result of the calculation in the visual?

> No filter on page although and visual 

Are the values in the visual calculated by a column or measure? If it's a measure are you applying any filters here?
> Actuall I'm just drag and drop to values table, and distinct the the value 

Are you using a date dimension table to pull in the month names to the visual? If you have a date dimension are the dates in both the date dimension and your fact table formatted in the same way, i.e. US format or European format?

> Yep I'm using date dimension. And the format of date in dim date table with date in the fact table are match

Regards

[Adescrit]

Hi @chrisyan_manalu ,

I expect that the reason is some of the distinct values within months also appear within other months. For example value A appears as a distinct value when looking specifically at Jan and Mar, so is counted as a dicstinct value for each of those months, but then when calculating the distinct values over the full year, value A would only be counted once.

Please check this. If you need help to summarise differently, for example you want the total to sum the distinct values within each month, let me know.

[Adescrit]

Hi @chrisyan_manalu 

Are there any other filters on the page or visual that could be impacting the result of the calculation in the visual?

Are the values in the visual calculated by a column or measure? If it's a measure are you applying any filters here?

Are you using a date dimension table to pull in the month names to the visual? If you have a date dimension are the dates in both the date dimension and your fact table formatted in the same way, i.e. US format or European format?


A few things to consider / investigate. With more information about your data model I might be able to pinpoint the issue.